OraFAQ Forum: Performance Tuning » get AWR report data

Home » RDBMS Server » Performance Tuning » get AWR report data (Oracle,10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

get AWR report data [message #563099]

Wed, 08 August 2012 10:18

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?

Report message to a moderator

Re: get AWR report data [message #563102 is a reply to message #563099]

Wed, 08 August 2012 11:25

Michel Cadot
Messages: 68454
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

Report message to a moderator

Re: get AWR report data [message #563153 is a reply to message #563102]

Thu, 09 August 2012 01:44

savugar
Messages: 33
Registered: February 2012

Member

it would be helpful for me if you could share the scripts for this.

Report message to a moderator

Re: get AWR report data [message #563155 is a reply to message #563153]

Thu, 09 August 2012 01:51

Michel Cadot
Messages: 68454
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

Report message to a moderator

Re: get AWR report data [message #563160 is a reply to message #563155]

Thu, 09 August 2012 02:13

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.

Report message to a moderator

Re: get AWR report data [message #563161 is a reply to message #563160]

Thu, 09 August 2012 02:25

Michel Cadot
Messages: 68454
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

Report message to a moderator

Re: get AWR report data [message #563163 is a reply to message #563161]

Thu, 09 August 2012 02:45

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.

Report message to a moderator

Previous Topic:	Increased LOGFILE did not increase performance
Next Topic:	Table actual size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 04 20:13:21 CDT 2023