DBA Data[Home] [Help]

VIEW: SYS.GV_$LOGMNR_LOGS

Source

View Text - Preformatted

select "INST_ID","LOG_ID","FILENAME","LOW_TIME","HIGH_TIME","DB_ID","DB_NAME","RESET_SCN","RESET_SCN_TIME","COMPATIBLE","THREAD_ID","THREAD_SQN","LOW_SCN","NEXT_SCN","DICTIONARY_BEGIN","DICTIONARY_END","TYPE","BLOCKSIZE","FILESIZE","INFO","STATUS","CON_ID" from gv$logmnr_logs
View Text - HTML Formatted

SELECT "INST_ID"
, "LOG_ID"
, "FILENAME"
, "LOW_TIME"
, "HIGH_TIME"
, "DB_ID"
, "DB_NAME"
, "RESET_SCN"
, "RESET_SCN_TIME"
, "COMPATIBLE"
, "THREAD_ID"
, "THREAD_SQN"
, "LOW_SCN"
, "NEXT_SCN"
, "DICTIONARY_BEGIN"
, "DICTIONARY_END"
, "TYPE"
, "BLOCKSIZE"
, "FILESIZE"
, "INFO"
, "STATUS"
, "CON_ID"
FROM GV$LOGMNR_LOGS