[Home] [Help] [Dependency Information]
Object Name: | GV_$LOGMNR_CONTENTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, 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.GV_$LOGMNR_CONTENTS;
|
|
|