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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment