GV$LOGMNR_DICTIONARY
select INST_ID, -- INST_ID NUMBER TIMESTAMP, -- TIMESTAMP DATE DB_ID, -- DB_ID NUMBER DB_NAME, -- DB_NAME VARCHAR2(8) FILENAME, -- FILENAME VARCHAR2(513) DICTIONARY_SCN, -- DICTIONARY_SCN NUMBER RESET_SCN, -- RESET_SCN NUMBER RESET_SCN_TIME, -- RESET_SCN_TIME DATE ENABLED_THREAD_MAP, -- ENABLED_THREAD_MAP RAW(16) INFO, -- INFO VARCHAR2(32) STATUS -- STATUS NUMBER from x$logmnr_dictionary

home |  up  |  mailbox