Monday, May 3, 2010

How to find usage of Advisors in Oracle (DBA_ADVISOR_USAGE)

There are views named dba_feature_usage_statistics and dba_advisor_usage which record usage of the new features. These reports indicate that the user needs to purchase the license for the additional products. In other words, usage of features like AWR, ASH and ADDM is recorded in the database

DBA_ADVISOR_USAGE displays the usage information for each type of advisor in the database

SQL>select u.ADVISOR_ID,d.ADVISOR_NAME,u.LAST_EXEC_TIME ,u.NUM_EXECS 
from DBA_ADVISOR_USAGE u,DBA_ADVISOR_DEFINITIONS d 
where u.ADVISOR_ID=d.ADVISOR_ID;

ADVISOR_ID ADVISOR_NAME LAST_EXEC_ NUM_EXECS
---------- ------------------------------ ---------- ---------
1 ADDM                              19/06/2008 2
2 SQL Access Advisor      22/07/2006 0
3 Undo Advisor                   22/07/2006 0
4 SQL Tuning Advisor        22/07/2006 0
5 Segment Advisor             28/04/2010 9436
6 SQL Workload Manager 22/07/2006 0
7 Tune MView                      22/07/2006 0


Related Topics
How do I check How much Oracle licence needed for my database
How To Verify Which Database Options are Used in Oracle

No comments: