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

VIEW: SYS.CDB_LOGMNR_SESSION

Object Details
Object Name: CDB_LOGMNR_SESSION
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
NAME VARCHAR2 (128) Yes
SOURCE_DATABASE VARCHAR2 (128)
SOURCE_DBID NUMBER

SOURCE_RESETLOGS_SCN NUMBER

SOURCE_RESETLOGS_TIME NUMBER

FIRST_SCN NUMBER

END_SCN NUMBER

BRANCH_SCN NUMBER

WAIT_FOR_LOG VARCHAR2 (3)
HOT_MINE VARCHAR2 (3)
SAFE_PURGE_SCN NUMBER

CHECKPOINT_SCN NUMBER

CON_ID NUMBER

container id
Query Text

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


SELECT ID
,      NAME
,      SOURCE_DATABASE
,      SOURCE_DBID
,      SOURCE_RESETLOGS_SCN
,      SOURCE_RESETLOGS_TIME
,      FIRST_SCN
,      END_SCN
,      BRANCH_SCN
,      WAIT_FOR_LOG
,      HOT_MINE
,      SAFE_PURGE_SCN
,      CHECKPOINT_SCN
,      CON_ID
FROM SYS.CDB_LOGMNR_SESSION;

Dependencies

[top of page]

SYS.CDB_LOGMNR_SESSION does not reference any database object

SYS.CDB_LOGMNR_SESSION is referenced by following:

SchemaPUBLIC
SynonymCDB_LOGMNR_SESSION