Oracle 视图 V$XSTREAM_CAPTURE 官方解释,作用,如何使用详细说明
V$XSTREAM_CAPTURE 视图是用来查看 XStream Capture 实例运行状态的一个视图。用此视图可以查看某个数据库实例下硬件级别的捕获器是否处于 running 状态的监控信息。
使用方法:
以 sys 用户身份登录 Oracle 数据库服务器,然后运行以下 SQL 语句来检查 XStream Capture 运行状态:
SELECT * FROM V$XSTREAM_CAPTURE;
如果结果显示 CAPTURE_STATE 为 RUNNING 则表示 XStream Capture 实例正在运行,否则则表示实例没有正常运行。
官方英文解释V$XSTREAM_CAPTURE displays information about each capture process that sends LCRs to an XStream outbound server.
Capture process number. A capture process is an Oracle background process prefixed by cp
WAITING FOR DICTIONARY REDO Waiting for redo log files containing the dictionary build related to the first SCN to be added to the capture process session. A capture process cannot begin to scan the redo log files until all of the log files containing the dictionary build have been added.
MINING (PROCESSED SCN = scn_value) Mining a dictionary build at the SCN scn_value.
LOADING (step X of Y) Processing information from a dictionary build and currently at step X in a process that involves Y steps, where X and Y are numbers.
CAPTURING CHANGES Scanning the redo log for changes that satisfy the capture process rule sets.
WAITING FOR REDO Waiting for new redo log files to be added to the capture process session. The capture process has finished processing all of the redo log files added to its session. This state is possible if there is no activity at a source database. For a downstream capture process, this state is possible if the capture process is waiting for new log files to be added to its session.
ENQUEUING MESSAGE Enqueuing an LCR that satisfies the capture process rule sets into the capture process queue.
PAUSED FOR FLOW CONTROL Unable to enqueue LCRs either because of low memory or because propagations and outbound servers are consuming messages slower than the capture process is creating them. This state indicates flow control that is used to reduce spilling of captured LCRs when propagation or apply has fallen behind or is unavailable.
WAITING FOR THE BUFFERED QUEUE TO SHRINK Waiting for the buffered queue to change to a smaller size. The buffered queue shrinks when there is a memory limitation or when an administrator reduces its size.
WAITING FOR n SUBSCRIBER(S) INITIALIZING Waiting for outbound servers that receive LCRs from the capture process to start, where n is the number of apply processes.
WAITING FOR INACTIVE DEQUEUERS Waiting for the capture process s queue subscribers to start. The capture process stops enqueuing LCRs if there are no active subscribers to the queue.
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.
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 WAITING FOR REDO state
The total amount of shared memory (in bytes) currently used by the capture process out of the amount allocated (SGA_ALLOCATED)
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
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
Note:
The ELAPSED_CAPTURE_TIME, ELAPSED_RULE_TIME, ELAPSED_ENQUEUE_TIME, ELAPSED_LCR_TIME, and ELAPSED_REDO_WAIT_TIME columns are only populated if the TIMED_STATISTICS initialization parameter is set to true, or if the STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL.
See Also:
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$XSTREAM_CAPTURE 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 ALL_APPLY_PROGRESS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_ALERT_HISTORY 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_ADVISOR_JOURNAL 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_WORKLOAD_CONNECTION_MAP 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_LOGMNR_SESSION 官方解释,作用,如何使用详细说明
- Oracle 视图 V$ASM_ALIAS 官方解释,作用,如何使用详细说明
- Oracle 等待事件 DFS lock handle 官方解释,作用,如何使用及优化方法
- 利用Oracle 100%潜力实现成功(oracle的使用)
- 使用Oracle调用存储函数的技巧(oracle调用存储函数)
- 深入理解Oracle中的字符类型(oracle中字符类型)
- 精通 Oracle 触发器:深入学习不同类型的触发器(oracle触发器类型)
- Oracle:数据库之父(第一个字符oracle)
- 函数Oracle窗口函数—为数据分析注入新的动力(oracle窗口)
- 利用Oracle字符连接符连接字符串(oracle字符连接符)
- Oracle最大化内存使用的窍门(oracle最大内存)
- 使用Oracle视图和IF语句让数据查询更高效(oracle视图if)
- Oracle共享内存管理配置技巧(oracle共享内存配置)
- 高效率实施Oracle数据库备份策略的DBA(dba备份oracle)
- 留存无忧使用Byte存储存入Oracle(byte 存oracle)
- 拍案叫绝bat重启Oracle(bat 重启oracle)
- 库管理管理Oracle数据库,高效完善体系(oracle 中的数据)
- Oracle让你拥有亿级表格瞬间查询能力(oracle 亿级表)
- Oracle云改变企业数字转型的解决方案(oracle云 介绍)
- Oracle数据库中序列的建立及其使用(oracle中序列的建立)
- Oracle中ON关键字的精彩运用(oracle中on的使用)
- Oracle数据库中不涵盖X字母(oracle不包含某字母)
- 类型Oracle中的几种用户类型简介(oracle下有几个用户)
- Oracle SOAR新的方式拓展业务空间(oracle soar)