GV$LOGMNR_LOGS
select INST_ID, -- INST_ID NUMBER LOG_ID, -- LOG_ID NUMBER FILENAME, -- FILENAME VARCHAR2(512) LOW_TIME, -- LOW_TIME DATE HIGH_TIME, -- HIGH_TIME DATE DB_ID, -- DB_ID NUMBER DB_NAME, -- DB_NAME VARCHAR2(8) RESET_SCN, -- RESET_SCN NUMBER RESET_SCN_TIME, -- RESET_SCN_TIME DATE THREAD_ID, -- THREAD_ID NUMBER THREAD_SQN, -- THREAD_SQN NUMBER LOW_SCN, -- LOW_SCN NUMBER NEXT_SCN, -- NEXT_SCN NUMBER DICTIONARY_BEGIN, -- DICTIONARY_BEGIN VARCHAR2(3) DICTIONARY_END, -- DICTIONARY_END VARCHAR2(3) TYPE, -- TYPE VARCHAR2(7) BLOCKSIZE, -- BLOCKSIZE NUMBER FILESIZE, -- FILESIZE NUMBER INFO, -- INFO VARCHAR2(32) STATUS -- STATUS NUMBER from x$logmnr_logs

home |  up  |  mailbox