AWR and Standard Edition RAC?
tsangsirAug 16 2011 — edited Aug 18 2011I 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)