GV$LOGMNR_CONTENTS
select INST_ID, -- INST_ID NUMBER SCN, -- SCN NUMBER CSCN, -- CSCN NUMBER TIMESTAMP, -- TIMESTAMP DATE COMMIT_TIMESTAMP, -- COMMIT_TIMESTAMP DATE THREAD#, -- THREAD# NUMBER LOG_ID, -- LOG_ID NUMBER XIDUSN, -- XIDUSN NUMBER XIDSLT, -- XIDSLT NUMBER XIDSQN, -- XIDSQN NUMBER PXIDUSN, -- PXIDUSN NUMBER PXIDSLT, -- PXIDSLT NUMBER PXIDSQN, -- PXIDSQN NUMBER RBASQN, -- RBASQN NUMBER RBABLK, -- RBABLK NUMBER RBABYTE, -- RBABYTE NUMBER UBAFIL, -- UBAFIL NUMBER UBABLK, -- UBABLK NUMBER UBAREC, -- UBAREC NUMBER UBASQN, -- UBASQN NUMBER ABS_FILE#, -- ABS_FILE# NUMBER REL_FILE#, -- REL_FILE# NUMBER DATA_BLK#, -- DATA_BLK# NUMBER DATA_OBJ#, -- DATA_OBJ# NUMBER DATA_OBJD#, -- DATA_OBJD# NUMBER SEG_OWNER, -- SEG_OWNER VARCHAR2(32) SEG_NAME, -- SEG_NAME VARCHAR2(256) TABLE_NAME, -- TABLE_NAME VARCHAR2(32) SEG_TYPE, -- SEG_TYPE NUMBER SEG_TYPE_NAME, -- SEG_TYPE_NAME VARCHAR2(32) TABLE_SPACE, -- TABLE_SPACE VARCHAR2(32) ROW_ID, -- ROW_ID VARCHAR2(18) SESSION#, -- SESSION# NUMBER SERIAL#, -- SERIAL# NUMBER USERNAME, -- USERNAME VARCHAR2(30) SESSION_INFO, -- SESSION_INFO VARCHAR2(4000) TX_NAME, -- TX_NAME VARCHAR2(256) ROLLBACK, -- ROLLBACK NUMBER OPERATION, -- OPERATION VARCHAR2(32) OPERATION_CODE, -- OPERATION_CODE NUMBER SQL_REDO, -- SQL_REDO VARCHAR2(4000) SQL_UNDO, -- SQL_UNDO VARCHAR2(4000) RS_ID, -- RS_ID VARCHAR2(32) SEQUENCE#, -- SEQUENCE# NUMBER SSN, -- SSN NUMBER CSF, -- CSF NUMBER INFO, -- INFO VARCHAR2(32) STATUS, -- STATUS NUMBER REDO_VALUE, -- REDO_VALUE NUMBER UNDO_VALUE, -- UNDO_VALUE NUMBER SQL_COLUMN_TYPE, -- SQL_COLUMN_TYPE VARCHAR2(30) SQL_COLUMN_NAME, -- SQL_COLUMN_NAME VARCHAR2(30) REDO_LENGTH, -- REDO_LENGTH NUMBER REDO_OFFSET, -- REDO_OFFSET NUMBER UNDO_LENGTH, -- UNDO_LENGTH NUMBER UNDO_OFFSET, -- UNDO_OFFSET NUMBER DATA_OBJV#, -- DATA_OBJV# NUMBER SAFE_RESUME_SCN, -- SAFE_RESUME_SCN NUMBER XID, -- XID RAW(8) PXID, -- PXID RAW(8) AUDIT_SESSIONIDfrom -- AUDIT_SESSIONID NUMBER x$logmnr_contents where ROW_TYPE = 0

home |  up  |  mailbox