4.44 DBA_ADVISOR_USAGE

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
ADVISOR_NAME	VARCHAR2(128)	NOT NULL	Name of the advisor
LAST_EXEC_TIME	DATE	NOT NULL	Date of the last execution
NUM_EXECS	NUMBER	NOT NULL	Cumulative number of executions
NUM_DB_REPORTS	NUMBER	NOT NULL	Cumulative number of reports
FIRST_REPORT_TIME	DATE		Time of the first report
LAST_REPORT_TIME	DATE		Time of the last report