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

TABLE: SYSTEM.LOGMNR_SESSION_ACTIONS$

Object Details
Object Name: LOGMNR_SESSION_ACTIONS$
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: LOGMNR_SESSION_ACTION$_PK
  1. ColumnLOGMNRSESSION#
  2. ColumnACTIONNAME
Indexes
Index Type Uniqueness Tablespace Column
LOGMNR_SESSION_ACTION$_PK NORMAL UNIQUE TablespaceSYSAUX ColumnLOGMNRSESSION#
ColumnACTIONNAME
Columns
Name Datatype Length Mandatory Comments
FLAGSRUNTIME NUMBER

DROPSCN NUMBER

MODIFYTIME TIMESTAMP(6) (11)
DISPATCHTIME TIMESTAMP(6) (11)
DROPTIME TIMESTAMP(6) (11)
LCRCOUNT NUMBER

ACTIONNAME VARCHAR2 (30) Yes
LOGMNRSESSION# NUMBER
Yes
PROCESSROLE# NUMBER
Yes
ACTIONTYPE# NUMBER
Yes
FLAGSDEFINETIME NUMBER

CREATETIME TIMESTAMP(6) (11)
XIDUSN NUMBER

XIDSLT NUMBER

XIDSQN NUMBER

THREAD# NUMBER

STARTSCN NUMBER

STARTSUBSCN NUMBER

ENDSCN NUMBER

ENDSUBSCN NUMBER

RBASQN NUMBER

RBABLK NUMBER

RBABYTE NUMBER

SESSION# NUMBER

OBJ# NUMBER

ATTR1 NUMBER

ATTR2 NUMBER

ATTR3 NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 TIMESTAMP(6) (11)
SPARE4 VARCHAR2 (2000)
Query Text

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


SELECT FLAGSRUNTIME
,      DROPSCN
,      MODIFYTIME
,      DISPATCHTIME
,      DROPTIME
,      LCRCOUNT
,      ACTIONNAME
,      LOGMNRSESSION#
,      PROCESSROLE#
,      ACTIONTYPE#
,      FLAGSDEFINETIME
,      CREATETIME
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      THREAD#
,      STARTSCN
,      STARTSUBSCN
,      ENDSCN
,      ENDSUBSCN
,      RBASQN
,      RBABLK
,      RBABYTE
,      SESSION#
,      OBJ#
,      ATTR1
,      ATTR2
,      ATTR3
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYSTEM.LOGMNR_SESSION_ACTIONS$;

Dependencies

[top of page]

SYSTEM.LOGMNR_SESSION_ACTIONS$ does not reference any database object

SYSTEM.LOGMNR_SESSION_ACTIONS$ is referenced by following:

SchemaSYS
Package BodyDBMS_LOGMNR_INTERNAL - show dependent code