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

VIEW: SYS.V_$LOGMNR_SESSION

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER

SESSION_NAME VARCHAR2 (32)
SESSION_STATE VARCHAR2 (9)
DB_NAME VARCHAR2 (128)
DB_ID NUMBER

RESET_SCN NUMBER

RESET_TIMESTAMP NUMBER

RESET_TIME DATE

NUM_PROCESS NUMBER

CHUNK_SIZE NUMBER

START_SCN NUMBER

END_SCN NUMBER

SPILL_SCN NUMBER

PROCESSED_SCN NUMBER

PROCESSED_TIME DATE

PREPARED_SCN NUMBER

READ_SCN NUMBER

LOW_MARK_SCN NUMBER

CONSUMED_SCN NUMBER

MAX_MEMORY_SIZE NUMBER

USED_MEMORY_SIZE NUMBER

BUILDER_WORK_SIZE NUMBER

PREPARED_WORK_SIZE NUMBER

AVAILABLE_WORK_SIZE NUMBER

AVAILABLE_TXN NUMBER

AVAILABLE_COMMITTED_TXN NUMBER

DELIVERED_TXN NUMBER

DELIVERED_COMMITTED_TXN NUMBER

PINNED_TXN NUMBER

PINNED_COMMITTED_TXN NUMBER

CHECKPOINT_INTERVAL NUMBER

CON_ID NUMBER

Query Text

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


SELECT SESSION_ID
,      SESSION_NAME
,      SESSION_STATE
,      DB_NAME
,      DB_ID
,      RESET_SCN
,      RESET_TIMESTAMP
,      RESET_TIME
,      NUM_PROCESS
,      CHUNK_SIZE
,      START_SCN
,      END_SCN
,      SPILL_SCN
,      PROCESSED_SCN
,      PROCESSED_TIME
,      PREPARED_SCN
,      READ_SCN
,      LOW_MARK_SCN
,      CONSUMED_SCN
,      MAX_MEMORY_SIZE
,      USED_MEMORY_SIZE
,      BUILDER_WORK_SIZE
,      PREPARED_WORK_SIZE
,      AVAILABLE_WORK_SIZE
,      AVAILABLE_TXN
,      AVAILABLE_COMMITTED_TXN
,      DELIVERED_TXN
,      DELIVERED_COMMITTED_TXN
,      PINNED_TXN
,      PINNED_COMMITTED_TXN
,      CHECKPOINT_INTERVAL
,      CON_ID
FROM SYS.V_$LOGMNR_SESSION;

Dependencies

[top of page]

SYS.V_$LOGMNR_SESSION references the following:

SYS.V_$LOGMNR_SESSION is referenced by following:

SchemaPUBLIC
SynonymV$LOGMNR_SESSION