DBA_LOGMNR_SESSION

5.157 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 Replication 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
`PURGE_SCN`	`NUMBER`		The session has been purged up to this SCN