VIEW: SYS.DBA_AUTOTASK_WINDOW_HISTORY

Source

View Text - Preformatted

SELECT WINDOW_NAME,
          LOG_DATE AS WINDOW_START_TIME,
          COALESCE(GREATEST((SELECT MIN(WCLOSE.LOG_DATE)
                            FROM DBA_SCHEDULER_WINDOW_LOG WCLOSE
                           WHERE WCLOSE.OPERATION='CLOSE'
                             AND WCLOSE.WINDOW_NAME = WOPEN.WINDOW_NAME
                             AND WCLOSE.LOG_DATE > WOPEN.LOG_DATE
                         ),
                         (SELECT MIN(WNEXT.LOG_DATE)
                            FROM DBA_SCHEDULER_WINDOW_LOG WNEXT
                           WHERE WNEXT.OPERATION='OPEN'
                             AND WNEXT.LOG_DATE >= WOPEN.LOG_DATE
                         )),
                   (SELECT SYSTIMESTAMP
                      FROM DBA_SCHEDULER_WINDOWS W
                     WHERE W.WINDOW_NAME =  WOPEN.WINDOW_NAME
                       AND W.ACTIVE = 'TRUE'),
                   (SELECT MIN(STARTUP_TIME)
                      FROM GV$INSTANCE I
                     WHERE I.STARTUP_TIME > WOPEN.LOG_DATE
                       AND I.STATUS = 'OPEN'),
                   SYSTIMESTAMP) AS WINDOW_END_TIME
        FROM DBA_SCHEDULER_WINDOW_LOG WOPEN
        WHERE WOPEN.OPERATION='OPEN'

View Text - HTML Formatted

SELECT WINDOW_NAME
, LOG_DATE AS WINDOW_START_TIME
, COALESCE(GREATEST((SELECT MIN(WCLOSE.LOG_DATE)
FROM DBA_SCHEDULER_WINDOW_LOG WCLOSE
WHERE WCLOSE.OPERATION='CLOSE'
AND WCLOSE.WINDOW_NAME = WOPEN.WINDOW_NAME
AND WCLOSE.LOG_DATE > WOPEN.LOG_DATE )
, (SELECT MIN(WNEXT.LOG_DATE)
FROM DBA_SCHEDULER_WINDOW_LOG WNEXT
WHERE WNEXT.OPERATION='OPEN'
AND WNEXT.LOG_DATE >= WOPEN.LOG_DATE ))
, (SELECT SYSTIMESTAMP
FROM DBA_SCHEDULER_WINDOWS W
WHERE W.WINDOW_NAME = WOPEN.WINDOW_NAME
AND W.ACTIVE = 'TRUE')
, (SELECT MIN(STARTUP_TIME)
FROM GV$INSTANCE I
WHERE I.STARTUP_TIME > WOPEN.LOG_DATE
AND I.STATUS = 'OPEN')
, SYSTIMESTAMP) AS WINDOW_END_TIME
FROM DBA_SCHEDULER_WINDOW_LOG WOPEN
WHERE WOPEN.OPERATION='OPEN'