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 |