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


TABLE: SYSTEM.LOGMNR_SESSION_EVOLVE$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: LOGMNR_SESSION_EVOLVE$_PK
  1. ColumnSESSION#
  2. ColumnDB_ID
  3. ColumnRESET_SCN
  4. ColumnRESET_TIMESTAMP
Indexes
Index Type Uniqueness Tablespace Column
LOGMNR_SESSION_EVOLVE$_PK NORMAL UNIQUE TablespaceSYSAUX ColumnSESSION#
ColumnDB_ID
ColumnRESET_SCN
ColumnRESET_TIMESTAMP
Columns
Name Datatype Length Mandatory Comments
BRANCH_LEVEL NUMBER

SESSION# NUMBER
Yes
DB_ID NUMBER
Yes
RESET_SCN NUMBER
Yes
RESET_TIMESTAMP NUMBER
Yes
PREV_RESET_SCN NUMBER

PREV_RESET_TIMESTAMP NUMBER

STATUS NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 DATE

Query Text

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


SELECT BRANCH_LEVEL
,      SESSION#
,      DB_ID
,      RESET_SCN
,      RESET_TIMESTAMP
,      PREV_RESET_SCN
,      PREV_RESET_TIMESTAMP
,      STATUS
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYSTEM.LOGMNR_SESSION_EVOLVE$;

Dependencies

[top of page]

SYSTEM.LOGMNR_SESSION_EVOLVE$ does not reference any database object

SYSTEM.LOGMNR_SESSION_EVOLVE$ is referenced by following:

SchemaSYS
Package BodyDBMS_LOGMNR_INTERNAL - show dependent code