Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWR and Standard Edition RAC?

tsangsirAug 16 2011 — edited Aug 18 2011
I know the option packs are not available in Standard Edition. However, In the "Oracle Database Licensing Information" document, it's said that Standard Edition RAC includes "Automatic Workload Management", which in turn includes AWR.

http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#BABDJGGI
http://download.oracle.com/docs/cd/E11882_01/rac.112/e16795/hafeats.htm#sthref412

Searching Oracle document showed that the phrase appeared only in these 2 location. So they should mean the same thing. That means if we run Standard Edition RAC, we should be able to run the AWR reports.

However, the report does not contain valuable information. Actually most of the AWR tables, like WRH$_SQLSTAT, WRH$_ACTIVE_SESSION_HISTORY are empty.

Any idea?


Oracle 11g 11.2.0.2 Standard Edition RAC
RHEL5.3 (surely irrelevant)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2011
Added on Aug 16 2011
7 comments
2,817 views