VIEW: SYS.DBA_LOGMNR_SESSION

Source

View Text - Preformatted

select
        s.session#              id,
        s.session_name          name,
        s.global_db_name        source_database,
        s.db_id                 source_dbid,
        s.resetlogs_change#     source_resetlogs_scn,
        s.reset_timestamp       source_resetlogs_time,
        s.start_scn             first_scn,
        s.end_scn               end_scn,
        s.branch_scn            branch_scn,
        case
         when (bitand(s.session_attr, 16) = 16) then 'YES'
         else  'NO'
        end                     wait_for_log,
        case
          when (bitand(s.session_attr, 8388608) = 8388608) then 'YES'
         else  'NO'
        end                     hot_mine,
        /* safe_purge_scn is the scn below or at which it is safe to purge */
        /* pass this scn into dbms_logmnr_session.purge_session */
        case /* case#0 :streams or logical standby */
             /* KRVX_RESTART_CKPT_ENABLED = 268435456 */
          when (bitand(s.session_attr, 268435456) = 268435456) then
            null
          else /* case #0 */
            s.spill_scn
          end    /* case #0 */
                                      safe_purge_scn,
        case /* case#0 :streams or logical standby */
          when (bitand(s.session_attr, 268435456) = 268435456) then
            get_max_checkpoint(s.session#)
          else
            null
          end
                                        checkpoint_scn
      from system.logmnr_session$ s

View Text - HTML Formatted

SELECT S.SESSION# ID
, S.SESSION_NAME NAME
, S.GLOBAL_DB_NAME SOURCE_DATABASE
, S.DB_ID SOURCE_DBID
, S.RESETLOGS_CHANGE# SOURCE_RESETLOGS_SCN
, S.RESET_TIMESTAMP SOURCE_RESETLOGS_TIME
, S.START_SCN FIRST_SCN
, S.END_SCN END_SCN
, S.BRANCH_SCN BRANCH_SCN
, CASE WHEN (BITAND(S.SESSION_ATTR
, 16) = 16) THEN 'YES' ELSE 'NO' END WAIT_FOR_LOG
, CASE WHEN (BITAND(S.SESSION_ATTR
, 8388608) = 8388608) THEN 'YES' ELSE 'NO' END HOT_MINE
, /* SAFE_PURGE_SCN IS THE SCN BELOW OR AT WHICH IT IS SAFE TO PURGE */ /* PASS THIS SCN INTO DBMS_LOGMNR_SESSION.PURGE_SESSION */ CASE /* CASE#0 :STREAMS OR LOGICAL STANDBY */ /* KRVX_RESTART_CKPT_ENABLED = 268435456 */ WHEN (BITAND(S.SESSION_ATTR
, 268435456) = 268435456) THEN NULL ELSE /* CASE #0 */ S.SPILL_SCN END /* CASE #0 */ SAFE_PURGE_SCN
, CASE /* CASE#0 :STREAMS OR LOGICAL STANDBY */ WHEN (BITAND(S.SESSION_ATTR
, 268435456) = 268435456) THEN GET_MAX_CHECKPOINT(S.SESSION#) ELSE NULL END CHECKPOINT_SCN
FROM SYSTEM.LOGMNR_SESSION$ S