OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » AWR and ADDR

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

AWR and ADDR [message #250102]

Sat, 07 July 2007 20:57

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.

Report message to a moderator

Re: AWR and ADDR [message #250114 is a reply to message #250102]

Sun, 08 July 2007 01:37

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

Report message to a moderator

Re: AWR and ADDR [message #250141 is a reply to message #250114]

Sun, 08 July 2007 11:33

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

Report message to a moderator

Re: AWR and ADDR [message #250148 is a reply to message #250141]

Sun, 08 July 2007 12:02

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

Report message to a moderator

Previous Topic:	Create first local database
Next Topic:	DBConsole Crashes with Page Cannot Be Displayed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:09:16 CDT 2024