select
l.session# logmnr_session_id,
l.file_name name,
l.db_id dbid,
l.resetlogs_change# resetlogs_scn,
l.reset_timestamp resetlogs_time,
l.timestamp modified_time,
l.thread# thread#,
l.sequence# sequence#,
l.first_change# first_scn,
l.next_change# next_scn,
l.first_time first_time,
l.next_time next_time,
l.dict_begin dictionary_begin,
l.dict_end dictionary_end,
case
when (bitand(l.status, 2) = 2) then
'NO'
else
'YES'
end keep,
case
when (bitand(l.status, 4) = 4) then
'YES'
else
'NO'
end suspect
from system.logmnr_log$ l
where bitand(l.flags, 16) != 16
SELECT
L.SESSION# LOGMNR_SESSION_ID
,
L.FILE_NAME NAME
,
L.DB_ID DBID
,
L.RESETLOGS_CHANGE# RESETLOGS_SCN
,
L.RESET_TIMESTAMP RESETLOGS_TIME
,
L.TIMESTAMP MODIFIED_TIME
,
L.THREAD# THREAD#
,
L.SEQUENCE# SEQUENCE#
,
L.FIRST_CHANGE# FIRST_SCN
,
L.NEXT_CHANGE# NEXT_SCN
,
L.FIRST_TIME FIRST_TIME
,
L.NEXT_TIME NEXT_TIME
,
L.DICT_BEGIN DICTIONARY_BEGIN
,
L.DICT_END DICTIONARY_END
,
CASE
WHEN (BITAND(L.STATUS
, 2) = 2) THEN
'NO'
ELSE
'YES'
END KEEP
,
CASE
WHEN (BITAND(L.STATUS
, 4) = 4) THEN
'YES'
ELSE
'NO'
END SUSPECT
FROM SYSTEM.LOGMNR_LOG$ L
WHERE BITAND(L.FLAGS
, 16) != 16
|
|
|