VIEW: SYS.DBA_ADVISOR_USAGE

Source

View Text - Preformatted

select a.advisor_id,
            d.name as advisor_name,
            a.last_exec_time,
            a.num_execs,
            a.num_db_reports,
            a.first_report_time,
            a.last_report_time
     from sys.wri$_adv_usage a, sys.wri$_adv_definitions d
     where a.advisor_id = d.id and a.advisor_id > 0

View Text - HTML Formatted

SELECT A.ADVISOR_ID
, D.NAME AS ADVISOR_NAME
, A.LAST_EXEC_TIME
, A.NUM_EXECS
, A.NUM_DB_REPORTS
, A.FIRST_REPORT_TIME
, A.LAST_REPORT_TIME
FROM SYS.WRI$_ADV_USAGE A
, SYS.WRI$_ADV_DEFINITIONS D
WHERE A.ADVISOR_ID = D.ID
AND A.ADVISOR_ID > 0