4.48 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