[Home] [Help] [Dependency Information]
Object Name: | V_$LOGMNR_TRANSACTION |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | |||
XID | RAW | (8) | ||
XIDUSN | NUMBER | |||
XIDSLT | NUMBER | |||
XIDSQN | NUMBER | |||
PARENT_XID | RAW | (8) | ||
PARENT_XIDUSN | NUMBER | |||
PARENT_XIDSLT | NUMBER | |||
PARENT_XIDSQN | NUMBER | |||
START_TIME | DATE | |||
START_SCN | NUMBER | |||
CHUNK# | NUMBER | |||
TOTAL_CHUNKS | NUMBER | |||
REDO_THREAD | NUMBER | |||
LOW_TIME | DATE | |||
LOW_SCN | NUMBER | |||
HIGH_TIME | DATE | |||
HIGH_SCN | NUMBER | |||
LCR_COUNT | NUMBER | |||
SPILLED_LCR_COUNT | NUMBER | |||
DFLAG | NUMBER | |||
MFLAG | NUMBER | |||
MFLAG2 | NUMBER | |||
STATE | VARCHAR2 | (32) | ||
TYPE | VARCHAR2 | (32) | ||
MINING_STATUS | VARCHAR2 | (32) | ||
QUEUE | VARCHAR2 | (32) | ||
SRC_CON_ID | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, XID
, XIDUSN
, XIDSLT
, XIDSQN
, PARENT_XID
, PARENT_XIDUSN
, PARENT_XIDSLT
, PARENT_XIDSQN
, START_TIME
, START_SCN
, CHUNK#
, TOTAL_CHUNKS
, REDO_THREAD
, LOW_TIME
, LOW_SCN
, HIGH_TIME
, HIGH_SCN
, LCR_COUNT
, SPILLED_LCR_COUNT
, DFLAG
, MFLAG
, MFLAG2
, STATE
, TYPE
, MINING_STATUS
, QUEUE
, SRC_CON_ID
, CON_ID
FROM SYS.V_$LOGMNR_TRANSACTION;
|
|
|