eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$LOGMNR_CONTENTS

Object Details

Object Name:	V_$LOGMNR_CONTENTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SCN	NUMBER
START_SCN	NUMBER
COMMIT_SCN	NUMBER
TIMESTAMP	DATE
START_TIMESTAMP	DATE
COMMIT_TIMESTAMP	DATE
XIDUSN	NUMBER
XIDSLT	NUMBER
XIDSQN	NUMBER
XID	RAW	(8)
PXIDUSN	NUMBER
PXIDSLT	NUMBER
PXIDSQN	NUMBER
PXID	RAW	(8)
TX_NAME	VARCHAR2	(256)
OPERATION	VARCHAR2	(32)
OPERATION_CODE	NUMBER
ROLLBACK	NUMBER
SEG_OWNER	VARCHAR2	(32)
SEG_NAME	VARCHAR2	(256)
TABLE_NAME	VARCHAR2	(32)
SEG_TYPE	NUMBER
SEG_TYPE_NAME	VARCHAR2	(32)
TABLE_SPACE	VARCHAR2	(32)
ROW_ID	VARCHAR2	(18)
USERNAME	VARCHAR2	(30)
OS_USERNAME	VARCHAR2	(4000)
MACHINE_NAME	VARCHAR2	(4000)
AUDIT_SESSIONID	NUMBER
SESSION#	NUMBER
SERIAL#	NUMBER
SESSION_INFO	VARCHAR2	(4000)
THREAD#	NUMBER
SEQUENCE#	NUMBER
RBASQN	NUMBER
RBABLK	NUMBER
RBABYTE	NUMBER
UBAFIL	NUMBER
UBABLK	NUMBER
UBAREC	NUMBER
UBASQN	NUMBER
ABS_FILE#	NUMBER
REL_FILE#	NUMBER
DATA_BLK#	NUMBER
DATA_OBJ#	NUMBER
DATA_OBJV#	NUMBER
DATA_OBJD#	NUMBER
SQL_REDO	VARCHAR2	(4000)
SQL_UNDO	VARCHAR2	(4000)
RS_ID	VARCHAR2	(32)
SSN	NUMBER
CSF	NUMBER
INFO	VARCHAR2	(64)
STATUS	NUMBER
REDO_VALUE	NUMBER
UNDO_VALUE	NUMBER
SAFE_RESUME_SCN	NUMBER
CSCN	NUMBER
OBJECT_ID	RAW	(16)
EDITION_NAME	VARCHAR2	(30)
CLIENT_ID	VARCHAR2	(64)
SRC_CON_NAME	VARCHAR2	(30)
SRC_CON_ID	NUMBER
SRC_CON_UID	NUMBER
SRC_CON_DBID	NUMBER
SRC_CON_GUID	RAW	(16)
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SCN
,      START_SCN
,      COMMIT_SCN
,      TIMESTAMP
,      START_TIMESTAMP
,      COMMIT_TIMESTAMP
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      XID
,      PXIDUSN
,      PXIDSLT
,      PXIDSQN
,      PXID
,      TX_NAME
,      OPERATION
,      OPERATION_CODE
,      ROLLBACK
,      SEG_OWNER
,      SEG_NAME
,      TABLE_NAME
,      SEG_TYPE
,      SEG_TYPE_NAME
,      TABLE_SPACE
,      ROW_ID
,      USERNAME
,      OS_USERNAME
,      MACHINE_NAME
,      AUDIT_SESSIONID
,      SESSION#
,      SERIAL#
,      SESSION_INFO
,      THREAD#
,      SEQUENCE#
,      RBASQN
,      RBABLK
,      RBABYTE
,      UBAFIL
,      UBABLK
,      UBAREC
,      UBASQN
,      ABS_FILE#
,      REL_FILE#
,      DATA_BLK#
,      DATA_OBJ#
,      DATA_OBJV#
,      DATA_OBJD#
,      SQL_REDO
,      SQL_UNDO
,      RS_ID
,      SSN
,      CSF
,      INFO
,      STATUS
,      REDO_VALUE
,      UNDO_VALUE
,      SAFE_RESUME_SCN
,      CSCN
,      OBJECT_ID
,      EDITION_NAME
,      CLIENT_ID
,      SRC_CON_NAME
,      SRC_CON_ID
,      SRC_CON_UID
,      SRC_CON_DBID
,      SRC_CON_GUID
,      CON_ID
FROM SYS.V_$LOGMNR_CONTENTS;

Dependencies

[top of page]

SYS.V_$LOGMNR_CONTENTS references the following:

SYS.V_$LOGMNR_CONTENTS is referenced by following:

PUBLIC: V$LOGMNR_CONTENTS