GV$LOGMNR_LOGFILE
select inst_id, -- INST_ID NUMBER log_id, -- LOG_ID NUMBER filename, -- FILENAME VARCHAR2(513) low_time, -- LOW_TIME NUMBER next_time, -- NEXT_TIME NUMBER db_id, -- DB_ID NUMBER db_name, -- DB_NAME VARCHAR2(8) reset_scnwrp, -- RESET_SCNWRP NUMBER reset_scnbas, -- RESET_SCNBAS NUMBER reset_scn_time, -- RESET_SCN_TIME NUMBER thread_id, -- THREAD_ID NUMBER thread_sqn, -- THREAD_SQN NUMBER low_scnwrp, -- LOW_SCNWRP NUMBER low_scnbas, -- LOW_SCNBAS NUMBER next_scnwrp, -- NEXT_SCNWRP NUMBER next_scnbas, -- NEXT_SCNBAS NUMBER decode -- FILE_STATE VARCHAR2(13) (state, 0, 'FILE_NOT_OPEN', 1, 'FILE_OPEN', 2, 'DONE') from x$logmnr_logfile

home |  up  |  mailbox