select OBJECT_TYPE, -- OBJECT_TYPE VARCHAR2(18) OBJECT_TYPE_ID, -- OBJECT_TYPE_ID NUMBER SEGMENT_TYPE_ID, -- SEGMENT_TYPE_ID NUMBER OBJECT_ID, -- OBJECT_ID NUMBER HEADER_FILE, -- HEADER_FILE NUMBER HEADER_BLOCK, -- HEADER_BLOCK NUMBER TS_NUMBER -- TS_NUMBER NUMBER from gv$logmnr_sys_objects where inst_id = userenv('instance')