Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_LOGMNR_SESSION

DBA_LOGMNR_SESSION displays all active LogMiner persistent sessions in the database.

A persistent LogMiner session is created either by starting Data Guard SQL Apply on a logical standby database for the first time or by creating Streams capture.

Column Datatype NULL Description
ID NUMBER NOT NULL Unique session identifier
NAME VARCHAR2(128) NOT NULL Unique session name
SOURCE_DATABASE VARCHAR2(128)   Global name of the source database whose archived logs are to be mined in this persistent LogMiner session
SOURCE_DBID NUMBER   Database ID of the source database
SOURCE_RESETLOGS_SCN NUMBER   Resetlogs SCN associated with the incarnation of the source database whose archived logs are mined
SOURCE_RESETLOGS_TIME NUMBER   Resetlogs time associated with the incarnation of the source database whose archived logs are mined
FIRST_SCN NUMBER   Only modifications that occurred on or after this SCN can be mined using this persistent session
END_SCN NUMBER   No modifications that occurred on or after this SCN can be mined using this persistent session
BRANCH_SCN NUMBER   SCN at which a branch will be taken in terms of the incarnation corresponding to the source database. This implies a point-in-time recovery was performed at the source database at this SCN.
WAIT_FOR_LOG VARCHAR2(3)   Indicates whether the persistent session waits for RFS to register new archived logs or to fill gaps (YES) or not (NO)
HOT_MINE VARCHAR2(3)   Indicates whether real-time mining is on (YES) or not (NO)
SAFE_PURGE_SCN NUMBER   Persistent session can safely be purged up to this SCN
CHECKPOINT_SCN NUMBER   SCN at which the latest checkpoint is taken by the persistent LogMiner session