Oracle 视图 V$LOGMNR_PROCESS 官方解释，作用，如何使用详细说明
本站中文解释
ES
V$LOGMNR_PROCESSES 视图用于显示正在运行的 Oracle LogMiner 会话。每个 LogMiner 会话都有一行记录。Oracle LogMiner 被用于日志数据分析。它可以从变更日志中识别不同类型的 DML （数据库语句），以及对应字段的旧值和新值。
使用此视图的步骤如下：
1、首先，确保 LogMiner 被正确设置，并设置 DBMS_LOGMNR.START_LOGMNR 存储过程。
2、然后，查询 V$LOGMNR_PRCESSES 视图，以显示当前运行的 LogMiner 会话，如：SELECT * FROM V$LOGMNR_PRCESSES;
3、根据输出，确定会话的情况，状态等信息，并使用适当的命令停止或重新启动该会话。
官方英文解释
V$LOGMNR_PROCESS identifies all processes attached to an active LogMiner persistent session.
(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.) This view can be joined with either the V$SESSION view or the V$PROCESS view to gather process-specific information.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Unique identifier for the LogMiner persistent session |
|
|
|
Oracle process identifier for the SQL Apply or Replication capture process (same as the |
|
|
|
Operating system process identifier (same as the |
|
|
|
Identifies the role of the active LogMiner process: |
|
|
|
Operating system process user name that is connected to the database |
|
|
|
Session identifier for the |
|
|
|
Session serial number associated with the |
|
|
|
Address of the latch the process is waiting for; |
|
|
|
This column is obsolete |
|
|
|
Microseconds spent by the process doing useful work |
|
|
|
Microseconds spent by the process doing overhead tasks or simply waiting/idling |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
“V$SESSION”
-
“V$PROCESS”
