VIEW: SYS.DBA_SCHEDULER_WINDOW_DETAILS

Source

View Text - Preformatted

(SELECT
        w.LOG_ID, w.LOG_DATE,
        CASE
          WHEN e.OWNER IS NULL THEN 'SYS'
          ELSE e.OWNER
        END,
        e.NAME, w.REQ_START_DATE, w.START_DATE,
        w.DURATION, w.ACTUAL_DURATION, w.INSTANCE_ID, w.ADDITIONAL_INFO
  FROM scheduler$_window_details w, scheduler$_event_log e
  WHERE e.log_id = w.log_id
  AND e.type# = 69)

View Text - HTML Formatted

(SELECT W.LOG_ID
, W.LOG_DATE
, CASE WHEN E.OWNER IS NULL THEN 'SYS' ELSE E.OWNER END
, E.NAME
, W.REQ_START_DATE
, W.START_DATE
, W.DURATION
, W.ACTUAL_DURATION
, W.INSTANCE_ID
, W.ADDITIONAL_INFO
FROM SCHEDULER$_WINDOW_DETAILS W
, SCHEDULER$_EVENT_LOG E
WHERE E.LOG_ID = W.LOG_ID
AND E.TYPE# = 69)