Home » RDBMS Server » Performance Tuning » get AWR report data (Oracle,10.2.0.4)
get AWR report data [message #563099] Wed, 08 August 2012 10:18 Go to next message
savugar
Messages: 33
Registered: February 2012
Member
I am having only select_catalog_role in database. Can I take complete AWR report data from awr views without using DBMS_WORKLOAD_REPOSITORY package?
Re: get AWR report data [message #563102 is a reply to message #563099] Wed, 08 August 2012 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, querying yourself the AWR tables but not using the AWR package.

Regards
Michel
Re: get AWR report data [message #563153 is a reply to message #563102] Thu, 09 August 2012 01:44 Go to previous messageGo to next message
savugar
Messages: 33
Registered: February 2012
Member
it would be helpful for me if you could share the scripts for this.
Re: get AWR report data [message #563155 is a reply to message #563153] Thu, 09 August 2012 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
May I ask why you don't want to use the package?

Regards
Michel
Re: get AWR report data [message #563160 is a reply to message #563155] Thu, 09 August 2012 02:13 Go to previous messageGo to next message
savugar
Messages: 33
Registered: February 2012
Member
I am working as a schema dba. So I have only select_catalog_role privs and dont have access to database server. There is one more team in client side is having all the privs. If I need report, I have to raise a ticket to this team.
But for analyzing the performance issues,I need AWR report always. but I have to wait some time to get the report. So my manager asked me to find a way to get the awr reports from awr views.
Re: get AWR report data [message #563161 is a reply to message #563160] Thu, 09 August 2012 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Couldn't you ask for execute privileges on this package? If this is part of your work, I don't see any reason to refuse it.
I bet if you ask them for 3, 4 or 10 reports each day they will fastly grant you access to the package.

Anyway, the information are in the DBA_HIST% views, study them and build your queries as you like for the results you want.
Check Alan Kendall's posts, he gives many scripts.
And you have Google, I bet you'll find many there too.

Regards
Michel
Re: get AWR report data [message #563163 is a reply to message #563161] Thu, 09 August 2012 02:45 Go to previous message
savugar
Messages: 33
Registered: February 2012
Member
Thanks Michel. I know it is not easy to write a script for fetching all the awr report data. However I will try.
Previous Topic: Increased LOGFILE did not increase performance
Next Topic: Table actual size
Goto Forum:
  


Current Time: Mon Jul 13 07:31:40 CDT 2020