Oracle 视图 DBA_LOGMNR_SESSION 官方解释，作用，如何使用详细说明
本站中文解释
Oracle的视图DBA_LOGMNR_SESSION用于查看运行中的LogMiner会话信息。LogMiner可以分析出redo log文件中的所有用户更改操作，当问题发生时，DBA_LOGMNR_SESSION可以帮助分析问题，比如检查数据库中是否恶意更改，以及检查数据库恢复正常时，执行的操作类型。
使用DBA_LOGMNR_SESION需要运行LogMiner，然后指定要维护的redo log文件和账户，在启动LogMiner之前需要设置一些参数，比如设定LogMiner使用哪种日志文件格式，以及如何处理LogMiner中的时间和日期。
使用DBA_LOGMNR_SESSION，可以从Sys此户列出所有正在运行的LogMiner会话。用户可以查看会话的ID，信息，类型，开始时间，状态等信息，例如：
SELECT SESSION_ID, NAME, TYPE, STATE, START_TIME FROM SYS.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 |
