GV$LOGMNR_DICTIONARY
select INST_ID, -- INST_ID NUMBER DB_NAME, -- DB_NAME VARCHAR2(9) DB_ID, -- DB_ID NUMBER DB_CREATED, -- DB_CREATED DATE TIMESTAMP, -- TIMESTAMP DATE RESET_SCN, -- RESET_SCN NUMBER RESET_SCN_TIME, -- RESET_SCN_TIME DATE DB_VERSION_TIME, -- DB_VERSION_TIME DATE DB_CHARACTER_SET, -- DB_CHARACTER_SET VARCHAR2(30) DB_VERSION, -- DB_VERSION VARCHAR2(64) DB_STATUS, -- DB_STATUS VARCHAR2(64) DICTIONARY_SCN, -- DICTIONARY_SCN NUMBER ENABLED_THREAD_MAP, -- ENABLED_THREAD_MAP RAW(16) DB_TXN_SCN, -- DB_TXN_SCN NUMBER FILENAME, -- FILENAME VARCHAR2(512) INFO, -- INFO VARCHAR2(32) STATUS -- STATUS NUMBER from x$logmnr_dictionary

home |  up  |  mailbox