OraFAQ Forum: Performance Tuning » AWR report in 11g standard not supported?

Home » RDBMS Server » Performance Tuning » AWR report in 11g standard not supported? (11.2.0.1)

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

AWR report in 11g standard not supported? [message #489380]

Sat, 15 January 2011 09:49

sean1970
Messages: 13
Registered: January 2010

Junior Member

Hi,
I was trying to generate AWR report, but the report which got generated consist most of the sections without data. Later i came to know that AWR report is not fully supported in 11g? Is that true?

Thanks,
Sean

[Updated on: Sat, 15 January 2011 09:51]

Report message to a moderator

Re: AWR report in 11g standard not supported? [message #489381 is a reply to message #489380]

Sat, 15 January 2011 09:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Do as I did & post results

SQL> show parameter timed

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
timed_os_statistics		     integer	 0
timed_statistics		     boolean	 TRUE

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: AWR report in 11g standard not supported? [message #489388 is a reply to message #489381]

Sat, 15 January 2011 10:53

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And

SQL> show parameter statistics_level
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
statistics_level                     string      TYPICAL

Regards
Michel

[Updated on: Sat, 15 January 2011 10:53]

Report message to a moderator

Re: AWR report in 11g standard not supported? [message #489391 is a reply to message #489388]

Sat, 15 January 2011 11:11

sean1970
Messages: 13
Registered: January 2010

Junior Member

Is the answer for the same question?

Quote:

Hi,
I was trying to generate AWR report, but the report which got generated consist most of the sections without data. Later i came to know that AWR report is not fully supported in 11g? Is that true?

Report message to a moderator

Re: AWR report in 11g standard not supported? [message #489394 is a reply to message #489391]

Sat, 15 January 2011 11:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/pls/db112/search?remark=quick_search&word=AWR

Report message to a moderator

Re: AWR report in 11g standard not supported? [message #489426 is a reply to message #489391]

Sun, 16 January 2011 04:27

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Hi, Sean - what Michel and BS suspect is that your reports are incomplete because your database is not collecting the relevant information. The parameters they have asked you to check control this.

Report message to a moderator

Re: AWR report in 11g standard not supported? [message #489775 is a reply to message #489380]

Wed, 19 January 2011 00:31

sean1970
Messages: 13
Registered: January 2010

Junior Member

Thanks Jhon.

Sorry Michel and BlackSwan, I should have understood it. I was on leave so i could not reply on time. Please find the output below.

SQL> show parameter statistics_level;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
statistics_level                     string      TYPICAL
SQL> show parameter timed;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
timed_os_statistics                  integer     0
timed_statistics                     boolean     TRUE

Thanks,
Sean

[Updated on: Wed, 19 January 2011 01:13]

Report message to a moderator

Previous Topic:	Avoid chain rows
Next Topic:	Database Links

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 03:08:21 CST 2024