V$LOGMNR_CONTENTS各字段的意思

V$LOGMNR_CONTENTS视图包含日志历史记录信息。

查询此视图的用户，必须有select any transaction权限。查询此视图将按顺序读取归档的redo log文件。

列	数据类型	描述
SCN	NUMBER	System change number，oracle为了避免操作系统时间不同步等问题自己定义的在某个时间点定义数据库已提交版本的时间戳标记。 oracle为每个已提交的事务分配唯一的scn
CSCN	NUMBER	提交事务时的系统更改号scn；仅当DBMS_LOGMNR.START_LOGMNR()中启用COMMITTED_DATA_ONLY选项才有意义
TIMESTAMP	DATE	更改数据库时的时间戳
COMMIT_TIMESTAMP	DATE	事务提交时的时间戳。仅当DBMS_LOGMNR.START_LOGMNR()中启用COMMITTED_DATA_ONLY选项才有意义
THREAD#	NUMBER	对数据库进行更改的线程数
LOG_ID	NUMBER	此列已过期
XIDUSN	NUMBER	Transaction ID undo segment number of the transaction that generated the change
XIDSLT	NUMBER	Transaction ID slot number of the transaction that generated the change
XIDSQN	NUMBER	Transaction ID sequence number of the transaction that generated the change
PXIDUSN	NUMBER	Parent transaction ID undo segment number of a parallel transaction
PXIDSLT	NUMBER	Parent transaction ID slot number of a parallel transaction
PXIDSQN	NUMBER	Parent transaction ID sequence number of a parallel transaction
RBASQN	NUMBER	Sequence# associated with the Redo Block Address (RBA) of the redo record associated with the change
RBABLK	NUMBER	RBA block number within the log file
RBABYTE	NUMBER	RBA byte offset within the block
UBAFIL	NUMBER	Undo Block Address (UBA) file number identifying the file containing the undo block
UBABLK	NUMBER	UBA block number for the undo block
UBAREC	NUMBER	UBA record index within the undo block
UBASQN	NUMBER	UBA undo block sequence number
ABS_FILE#	NUMBER	Data block absolute file number of the block changed by the transaction
REL_FILE#	NUMBER	Data block relative file number. The file number is relative to the tablespace of the object
DATA_BLK#	NUMBER	Data block number within the file
DATA_OBJ#	NUMBER	Data block object number identifying the object
DATA_OBJD#	NUMBER	Data block data object number identifying the object within the tablespace
SEG_OWNER	VARCHAR2(32)	被修改段的owner，对应库表操作的模式名
SEG_NAME	VARCHAR2(256)	被修改数据段的名称，对应表名
TABLE_NAME	VARCHAR2(32)	被修改的表名
SEG_TYPE	NUMBER	修改数据段的类型. 值如下: 0 = UNKNOWN 1 = INDEX 2 = TABLE 19 = TABLE 分区 20 = INDEX 分区 34 = TABLE 子分区 其他= UNSUPPORTED
SEG_TYPE_NAME	VARCHAR2(32)	UNKNOWN INDEX TABLE TABLE PARTITION UNSUPPORTED TABLE_SPACE
TABLE_SPACE	VARCHAR2(32)	表空间。对于OPERATION列为ddl的行，不会填充此列。因为DDL语句可能操作多个表空间
ROW_ID	VARCHAR2(18)	所修改行的rowid。只有redo record与DML语句有关时才有值，否则为null
SESSION#	NUMBER	Session number of the session that made the change
SERIAL#	NUMBER	Serial number of the session that made the change
USERNAME	VARCHAR2(30)	哪个用户执行的此事务。值可能是unkown
SESSION_INFO	VARCHAR2(4000)	值可能是unkown Information about the database session that executed the transaction. Contains process information, machine name from which the user logged in etc. A possible SESSION_INFO column may contain the following: login_username = HR client_info = OS_username = jkundu Machine_name = nirvan OS_terminal = pts/31 OS_program_name = sqlplus@nirvan (TNS V1-V3)
TX_NAME	VARCHAR2(256)	事务名，仅在此事务是一个named事务时有效
ROLLBACK	NUMBER	1 表示存在关联事务的部分或者全部回滚的redo 记录 0 表示不存在
OPERATION	VARCHAR2(32)	Possible values are: INSERT = change was caused by an insert statement UPDATE = change was caused by an update statement DELETE = change was caused by a delete statement DDL = change was caused by a DDL statement START = change was caused by the start of a transaction COMMIT = change was caused by the commit of a transaction ROLLBACK = change was caused by a full rollback of a transaction LOB_WRITE = change was caused by an invocation of DBMS_LOB.WRITE LOB_TRIM = change was caused by an invocation of DBMS_LOB.TRIM LOB_ERASE = change was caused by an invocation of DBMS_LOB.ERASE SELECT_FOR_UPDATE = operation was a SELECT FOR UPDATE statement SEL_LOB_LOCATOR = operation was a SELECT statement that returns a LOB locator MISSING_SCN = LogMiner encountered a gap in the redo records. This is most likely because not all redo logs were registered with LogMiner. INTERNAL = change was caused by internal operations initiated by the database UNSUPPORTED = change was caused by operations not currently supported by LogMiner (for example, changes made to tables with ADT columns)
OPERATION_CODE	NUMBER	Number of the operation code. Possible values are: 0 = INTERNAL 1 = INSERT 2 = DELETE 3 = UPDATE 5 = DDL 6 = START 7 = COMMIT 9 = SELECT_LOB_LOCATOR 10 = LOB_WRITE 11 = LOB_TRIM 25 = SELECT_FOR_UPDATE 28 = LOB_ERASE 34 = MISSING_SCN 36 = ROLLBACK 255 = UNSUPPORTED
SQL_REDO	VARCHAR2(4000)	Reconstructed SQL statement that is equivalent to the original SQL statement that made the change. Please refer to Oracle Database Utilities before executing SQL_REDO to your database. LogMiner does not generate SQL redo for temporary tables. In such a case, this column will contain the string "/* No SQL_REDO for temporary tables */".
SQL_UNDO	VARCHAR2(4000)	Reconstructed SQL statement that can be used to undo the effect of the original statement that made the change. DDL statements have no corresponding SQL_UNDO. Please refer to Oracle Database Utilities before executing SQL_UNDO to your database. LogMiner does not generate SQL undo for temporary tables. In such a case, this column will contain the string "/* No SQL_UNDO for temporary tables */".
RS_ID	VARCHAR2(32)	Record set ID. The tuple (RS_ID, SSN) together uniquely identifies a row in V$LOGMNR_CONTENTS. RS_ID uniquely identifies the redo record that generated the row.
SEQUENCE#	NUMBER	包含于数据库更改相对应的redo record的redo log的序列号
SSN	NUMBER	SQL sequence number. Used in conjunction with RS_ID, this uniquely identifies a row in the V$LOGMNR_CONTENTS view.
CSF	NUMBER	Continuation SQL flag. Possible values are: 0 表示sql_redo， sql_undo在同一行 1 表示sql_redo或者sql_undo的大小大于4000个字节，并在视图的下一行中返回
INFO	VARCHAR2(32)	Informational message about the row. For instance, the string "USER DDL" in INFO column indicates that the DDL statement returned in SQL_REDO column was the top-level DDL executed by the user and the string "INTERNAL DDL" in INFO column indicates that DDL statement returned in SQL_REDO column was executed internally by the RDBMS.
STATUS	NUMBER	0表示sql_redo,sql_undo中的sql语句是可以执行的 否则，sql语句无法执行。可能是因为没有将数据字典提供给logminer或者提供的数字字典没有需要的对象
REDO_VALUE	NUMBER	用作DBMS_LOGMNR.MINE_VALUE()， DBMS_LOGMNR.COLUMN_PRESENT() 的输入参数
UNDO_VALUE	NUMBER	同上
SQL_COLUMN_TYPE	VARCHAR2(30)	This column is deprecated.
SQL_COLUMN_NAME	VARCHAR2(30)	This column is deprecated.
REDO_LENGTH	NUMBER	This column is deprecated.
REDO_OFFSET	NUMBER	This column is deprecated.
UNDO_LENGTH	NUMBER	This column is deprecated.
UNDO_OFFSET	NUMBER	This column is deprecated.
DATA_OBJV#	NUMBER	Version number of the table being modified
SAFE_RESUME_SCN	NUMBER	保留字段
XID	RAW(8)	原始二进制类型的事务标识符
PXID	RAW(8)	原始二进制类型的父事务标识符
AUDIT_SESSIONID	NUMBER	Audit session ID associated with the user session making the change