DBA_ADVISOR_USAGE

Oracle 11gR1

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

Column	Datatype	NULL	Description
ADVISOR_ID	NUMBER	NOT NULL	Type of the advisor
LAST_EXEC_TIME	DATE	NOT NULL	Date of the last execution
NUM_EXECS	NUMBER	NOT NULL	Cumulative number of executions

Note:

1.

select d.advisor_name,u.*

from DBA_ADVISOR_USAGE u, DBA_ADVISOR_DEFINITIONS d

where u.advisor_id = d.advisor_id;

ADVISOR_NAME	ADVISOR_ID	LAST_EXEC_TIME	NUM_EXECS
ADDM	1	2008-02-05 2:34:11 PM	20
SQL Access Advisor	2	2006-06-10 10:00:50 AM	0
Undo Advisor	3	2008-04-16 2:02:16 PM	1
SQL Tuning Advisor	4	2006-06-10 10:00:50 AM	0
Segment Advisor	5	2008-08-27 10:40:36 PM	2408
SQL Workload Manager	6	2006-06-10 10:00:50 AM	0
Tune MView	7	2006-06-10 10:00:50 AM	0

2. 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.

Oracle data dictionary views