Oracle 视图 V$GOLDENGATE_CAPTURE 官方解释,作用,如何使用详细说明
本站中文解释
用途和用法
Oracle视图V$GOLDENGATE_CAPTURE是一个`虚拟视图o`,用来从GoldenGate的采集进程中报告活动和状态信息,它由goldengate的处理程序动态更新,用于监视GoldenGate系统实例或采集进程。
V$GOLDENGATE_CAPTURE 视图提供以下相关信息:
* INSTANCE_NAME: 采集进程所属GoldenGate实例名称 。
* CAPTURED: SN YES表示采集进程正在运行,NO表示采集进程处于停止状态 。
* STATUS: 显示采集状态,比如正在采集,正在停止采集,准备重启等 。
* STARTUP_TIME: 表示采集服务启动时间 。
* WORKING_DIR: 表示采集进程的工作目录 。
要使用V$GOLDENGATE_CAPTURE视图,必须使用SYSDBA权限,并用如下语法运行查询:
“`
SELECT INSTANCE_NAME, CAPTURED, STATUS, STARTUP_TIME, WORKING_DIR
FROM V$GOLDENGATE_CAPTURE;
“`
官方英文解释
V$GOLDENGATE_CAPTURE
displays information about each capture process that sends LCRs to an Oracle GoldenGate outbound server.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier of the capture process |
|
|
Session serial number of the capture process session |
|
|
Capture process number. A capture process is an Oracle background process prefixed by |
|
|
Name of the capture process |
|
|
Session ID of the Oracle LogMiner session associated with the capture process |
|
|
Time when the capture process was last started |
|
|
State of the capture process and state of the network. The two states are separated by a semicolon. The possible values are:
|
|
|
Total number of prefiltered messages discarded |
|
|
Total number of prefiltered messages kept |
|
|
Total number of prefilter evaluations |
|
|
Total number of redo entries passed by LogMiner to the capture process for detailed rule evaluation since the capture process last started. A capture process converts a redo entry into a message and performs detailed rule evaluation on the message when capture process prefiltering cannot discard the change. |
|
|
Time when the most recent message was captured |
|
|
Number of the most recently captured message |
|
|
Creation time of the most recently captured message |
|
|
Count associated with |
|
|
Count associated with |
|
|
Total number of messages enqueued since the capture process was last started |
|
|
Time when the last message was enqueued |
|
|
Number of the last enqueued message |
|
|
Creation time of the last enqueued message |
|
|
For local capture, the last redo SCN flushed to the log files. For downstream capture, the last SCN added to LogMiner through the archived redo log files. |
|
|
For local capture, the time the SCN was written to the log file. For downstream capture, the time the most recent archived redo log file (containing the most recent SCN) was added to LogMiner. |
|
|
Elapsed time (in hundredths of a second) scanning for changes in the redo log since the capture process was last started |
|
|
Elapsed time (in hundredths of a second) evaluating rules since the capture process was last started |
|
|
Elapsed time (in hundredths of a second) enqueuing messages since the capture process was last started |
|
|
Elapsed time (in hundredths of a second) creating LCRs since the capture process was last started |
|
|
Elapsed time (in hundredths of a second) spent by the capture process in the |
|
|
Elapsed flow control pause time (in hundredths of a second) |
|
|
Time at which the state of the capture process changed |
|
|
The total amount of shared memory used (in bytes) by the capture process |
|
|
The total amount of shared memory (in bytes) allocated from the Streams pool for the capture process |
|
|
The total amount of redo data mined (in bytes) since the capture process last started |
|
|
The SCN from which the capture process started mining redo data when it was last started |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Operating system process identifier of the capture process |
|
|
Name of the extract process |
|
|
Session ID of the capture server |
|
|
Session serial number of the capture server |
|
|
Operating system process identifier of the capture server |
|
|
Total number of LCRs sent by the capture process to the GoldenGate extract process since the last time the extract attached to the capture |
|
|
Time the last LCR was sent by the capture process to the extract process |
|
|
Message number of the last LCR sent by the capture process to the extract process |
|
|
Creation time at the source database of the last LCR sent by the capture process to the extract process |
|
|
Time elapsed (in hundredths of a second) sending LCRs to the extract process since the last time the extract process attached to the capture process |
|
|
Total number of bytes sent by the capture process to the extract process since the last time the extract process attached to the capture process |