Home » RDBMS Server » Enterprise Manager » AWR and ADDR
AWR and ADDR [message #250102] Sat, 07 July 2007 20:57 Go to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
I recently read about using the AWR and ADDR features in the book "Oracle High Performance Tuning for 9i and 10g" by Gavin JT Powell. Could someone please confirm if these options are available from the Enterprise Manager Console for Oracle Standard Edition, because I am having difficulty installing Enterprise Manager for this version on a particular Oracle instance, and would like to confirm if it is worth perusing.

Ay advice is very much appreciated.
Re: AWR and ADDR [message #250114 is a reply to message #250102] Sun, 08 July 2007 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you meant ADDM.
I don't know if they are available in Standard Edition but I'm sure it is a paying option.

You can use:
SQL> select OCCUPANT_NAME,OCCUPANT_DESC from v$SYSAUX_OCCUPANTS where OCCUPANT_NAME like 'SM%' order by 1;
OCCUPANT_NAME                  OCCUPANT_DESC
------------------------------ ----------------------------------------------------------------
SM/ADVISOR                     Server Manageability - Advisor Framework
SM/AWR                         Server Manageability - Automatic Workload Repository
SM/OPTSTAT                     Server Manageability - Optimizer Statistics History
SM/OTHER                       Server Manageability - Other Components

4 rows selected.


What are your difficulties to install EE?

Regards
Michel
Re: AWR and ADDR [message #250141 is a reply to message #250114] Sun, 08 July 2007 11:33 Go to previous messageGo to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
Thanks Michel,

It seems that it is available with Standard Edition, but we're not allowed to access it! There is a table which records which features have been used:

DBA_FEATURE_USAGE_STATISTICS

http://www.freelists.org/archives/oracle-l/01-2007/msg00046.html

Re: AWR and ADDR [message #250148 is a reply to message #250141] Sun, 08 July 2007 12:02 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct, I forgot to mention this one:
SQL> Col name             format a43     heading "Feature"
SQL> Col detected_usages  format 999,990 heading "Detected|usages"
SQL> Col currently_used   format a06     heading "Curr.|used?"
SQL> select name, detected_usages, currently_used
  2  from dba_feature_usage_statistics
  3  where name in ('Automatic Workload Repository','Automatic Database Diagnostic Monitor')
  4  /
                                            Detected Curr.
Feature                                       usages used?
------------------------------------------- -------- ------
Automatic Database Diagnostic Monitor              0 FALSE
Automatic Workload Repository                      0 FALSE

2 rows selected.

Regards
Michel
Previous Topic: Create first local database
Next Topic: DBConsole Crashes with Page Cannot Be Displayed
Goto Forum:
  


Current Time: Thu Dec 08 18:26:25 CST 2016

Total time taken to generate the page: 0.09603 seconds