5.159 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 |
---|---|---|---|
|
|
|
Unique session identifier |
|
|
|
Unique session name |
|
|
|
Global name of the source database whose archived logs are to be mined in this persistent LogMiner session |
|
|
|
Database ID of the source database |
|
|
|
Resetlogs SCN associated with the incarnation of the source database whose archived logs are mined |
|
|
|
Resetlogs time associated with the incarnation of the source database whose archived logs are mined |
|
|
|
Only modifications that occurred on or after this SCN can be mined using this persistent session |
|
|
|
No modifications that occurred on or after this SCN can be mined using this persistent session |
|
|
|
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. |
|
|
|
Indicates whether the persistent session waits for RFS to register new archived logs or to fill gaps ( |
|
|
|
Indicates whether real-time mining is on ( |
|
|
|
Persistent session can safely be purged up to this SCN |
|
|
|
SCN at which the latest checkpoint is taken by the persistent LogMiner session |
|
|
|
The session has been purged up to this SCN |