Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$LOGMNR_CONTENTS

This view contains log history information.

When a SELECT statement is executed against the V$LOGMNR_CONTENTS view, the archive redo log files are read sequentially. Translated records from the redo log files are returned as rows in the V$LOGMNR_CONTENTS view. This continues until either the filter criteria specified at startup (EndTime or endScn) are met or the end of the archive log file is reached.

Column Datatype Description

SCN

NUMBER

System change number (SCN) when the redo record was generated

CSCN

NUMBER

TIMESTAMP

DATE

Timestamp

COMMIT_TIMESTAMP

DATE

THREAD#

NUMBER

Number of the thread which generated the redo record

LOG_ID

NUMBER

Number of the log file which contains the redo record. This number is generated by LogMiner to uniquely identify a log, and corresponds to the LOG_ID column in V$LOGMNR_FILES.

XIDUSN

NUMBER

Transaction ID undo segment number of the transaction which generated the change

XIDSLT

NUMBER

Transaction ID slot number of the transaction which generated the change

XIDSQN

NUMBER

Transaction ID sequence number of the transaction which generated the change

RBASQN

NUMBER

RBA sequence number of the log that contained this redo record

RBABLK

NUMBER

RBA block number within the log file

RBABYTE

NUMBER

RBA byte offset within the block

UBAFIL

NUMBER

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_DOBJ#

NUMBER

Data block data object number identifying the object within the tablespace

SEG_OWNER

VARCHAR2(32)

Owner of the segment

SEG_NAME

VARCHAR2(256)

Name of the segment

SEG_TYPE

NUMBER

Segment type

SEG_TYPE_NAME

VARCHAR2(32)

Segment type name

TABLE_SPACE

VARCHAR2(32)

Tablespace name

ROW_ID

VARCHAR2(19)

Row ID

SESSION#

NUMBER

Session number of the session which generated the redo. A null value is reported if the session number is not available from the redo log.

SERIAL#

NUMBER

Serial number of the session which generated the redo. The session number and serial # can be used to uniquely identify the Oracle session. A null value is reported if the session number is not available from the redo log.

USERNAME

VARCHAR2(30)

User name

SESSION_INFO

VARCHAR2(4000)

Session information

ROLLBACK

NUMBER

Rollback request

OPERATION

VARCHAR2(30)

Operation

OPERATION_CODE

NUMBER

Operation code

SQL_REDO

VARCHAR2(4000)

SQL redo

SQL_UNDO

VARCHAR2(4000)

SQL undo

RS_ID

VARCHAR2(32)

Record set ID

SSN

NUMBER

SQL sequence number

CSF

NUMBER

Continuation SQL flag

INFO

VARCHAR2(32)

Informational message

STATUS

NUMBER

Status

REDO_VALUE

RAW(4)

UNDO_VALUE

RAW(4)

SQL_COLUMN_TYPE

VARCHAR2(32)

Type of data in the SQL_REDO and SQL_UNDO columns

SQL_COLUMN_NAME

VARCHAR2(32)

Name of the LOB or LONG columns

REDO_LENGTH

NUMBER

Length of the data value in the SQL_REDO column

REDO_OFFSET

NUMBER

Length of the data value in the SQL_REDO column

UNDO_LENGTH

NUMBER

Length of the data value in the SQL_UNDO column

UNDO_OFFSET

NUMBER

If SQL_COLUMN_TYPE is LOB_COLUMN or LONG_COLUMN, then this column contains the byte offset of the SQL_UNDO column data in the column indicated by SQL_COLUMN_NAME. Zero by default.