[Home] [Help] [Dependency Information]
Object Name: | LOGMNR_SESSION$ |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LOGMNR_SESSION_PK | NORMAL | UNIQUE | SYSTEM | SESSION# |
LOGMNR_SESSION_UK1 | NORMAL | UNIQUE | SYSTEM | SESSION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION# | NUMBER | Yes | ||
CLIENT# | NUMBER | |||
SESSION_NAME | VARCHAR2 | (128) | Yes | |
DB_ID | NUMBER | |||
RESETLOGS_CHANGE# | NUMBER | |||
SESSION_ATTR | NUMBER | |||
SESSION_ATTR_VERBOSE | VARCHAR2 | (400) | ||
START_SCN | NUMBER | |||
END_SCN | NUMBER | |||
SPILL_SCN | NUMBER | |||
RESUME_SCN | NUMBER | |||
OLDEST_SCN | NUMBER | |||
GLOBAL_DB_NAME | VARCHAR2 | (128) | ||
RESET_TIMESTAMP | NUMBER | |||
BRANCH_SCN | NUMBER | |||
VERSION | VARCHAR2 | (64) | ||
SPILL_TIME | DATE | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | NUMBER | |||
SPARE5 | NUMBER | |||
SPARE6 | DATE | |||
SPARE7 | VARCHAR2 | (1000) | ||
SPARE8 | VARCHAR2 | (1000) | ||
REDO_COMPAT | VARCHAR2 | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION#
, CLIENT#
, SESSION_NAME
, DB_ID
, RESETLOGS_CHANGE#
, SESSION_ATTR
, SESSION_ATTR_VERBOSE
, START_SCN
, END_SCN
, SPILL_SCN
, RESUME_SCN
, OLDEST_SCN
, GLOBAL_DB_NAME
, RESET_TIMESTAMP
, BRANCH_SCN
, VERSION
, SPILL_TIME
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, SPARE8
, REDO_COMPAT
FROM SYSTEM.LOGMNR_SESSION$;
SYSTEM.LOGMNR_SESSION$ does not reference any database object
SYSTEM.LOGMNR_SESSION$ is referenced by following:
|
|
|