VIEW: CTXSYS.CTX_AUTO_OPTIMIZE_STATUS

Source

View Text - Preformatted

select l.log_date aos_timestamp,
       l.status   aos_status,
       d.additional_info aos_error
  from user_scheduler_job_log l, user_scheduler_job_run_details d
  where l.log_id = d.log_id and
        l.owner = d.owner and
        l.owner = 'CTXSYS'

View Text - HTML Formatted

SELECT L.LOG_DATE AOS_TIMESTAMP
, L.STATUS AOS_STATUS
, D.ADDITIONAL_INFO AOS_ERROR
FROM USER_SCHEDULER_JOB_LOG L
, USER_SCHEDULER_JOB_RUN_DETAILS D
WHERE L.LOG_ID = D.LOG_ID AND L.OWNER = D.OWNER AND L.OWNER = 'CTXSYS'