Oracle 视图 V$STREAMS_APPLY_COORDINATOR 官方解释,作用,如何使用详细说明
V$STREAMS_APPLY_COORDINATOR是Oracle中的一个视图,它可以帮助DBA了解流应用程序的当前调度、控制和传输的状态、参数和统计信息。它可以用来帮助DBA查看当前应用程序的工作负载,排查问题,并测试实时流式处理应用程序的性能。
使用V$STREAMS_APPLY_COORDINATOR视图需要具有SYSDBA角色的权限。要理解上面的信息,视图中的表列及其含义,可以执行以下查询:
SELECT * FROM v$streams_apply_coordinator;
上面的查询可以输出表的各个列,其中有一些会显示当前流应用程序的传输状态、工作负载、性能统计等。下面是其中一些常见的列:
APPLY_NAME:应用程序的名称
DOP:并行度,指定应用程序将使用几个并发会话去解决查询
SCHEDULE:定义是否禁用调度器或仅使用它运行查询
CONSUMER_GROUP:该值对应了流使用的消费者组
MESSAGES_ENQUEUED:消息积压量
MESSAGES_DEQUEUED:已处理消息的数量
ENQUEUE_STALLED:未能在指定的时间内完成入队的消息的数量
DEQUEUE_ERRORS:尝试从队列中读取消息失败的数量
RULE_EVALUATOR_IDLE:用于识别规则的空闲会话的数量
APPLY_IDLE:适应器空闲会话的用量
Apply process number. An apply process coordinator is an Oracle background process, prefixed by ap.
Total number of transactions applied by the apply process since the apply process was last started
Number of times since the apply process was last started that an apply server waited to apply a logical change record (LCR) in a transaction until another apply server applied a transaction because of a dependency between the transactions
Number of times since the apply process was last started that an apply server waited to commit a transaction until another apply server committed a transaction to serialize commits
Number of transactions assigned to apply servers since the apply process was last started
Total number of transactions received by the coordinator process since the apply process was last started
Number of transactions which were received by the coordinator but were ignored because they had been previously applied
Number of transactions applied by the apply process that resulted in an apply error since the apply process was last started
Total number of complete transactions that the coordinator has not assigned to any apply servers
Current value of transaction buffer size. Transaction buffer size refers to the number of transactions that the apply reader can assemble ahead of apply servers. The apply process periodically adjusts the transaction buffer size.
Time when the message with the lowest message number was recorded. The creation time of the message with the lowest message number was also recorded at this time.
Number of the message corresponding to the low watermark. That is, messages with a commit message number less than or equal to this message number have definitely been applied, but some messages with a higher commit message number also may have been applied.
For captured messages, creation time at the source database of the message corresponding to the low watermark. For user-enqueued messages, time when the message corresponding to the low watermark was enqueued into the queue at the local database.
Time when the message with the highest message number was recorded. The creation time of the message with the highest message number was also recorded at this time.
Number of the message corresponding to the high watermark. That is, no messages with a commit message number greater than this message number have been applied.
For captured messages, creation time at the source database of the message corresponding to the high watermark. For user-enqueued messages, time when the message corresponding to the high watermark was enqueued into the queue at the local database.
Time elapsed (in hundredths of a second) scheduling messages since the apply process 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_SCHEDULE_TIME column is 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$STREAMS_APPLY_COORDINATOR 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 DBA_ADVISOR_COMMANDS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_RECYCLEBIN 官方解释,作用,如何使用详细说明
- Oracle 等待事件 Redo Transport Ping 官方解释,作用,如何使用及优化方法
- 解析Oracle中的单引号(oracle中单引号)
- 手把手指导:使用Oracle闪回技术(oracle闪回技术)
- Oracle数据库知识精析题库(oracle题库)
- 使用Oracle中的占位符加快SQL查询速度(oracle占位符)
- 用Oracle动态SQL轻松解决复杂问题(oracle动态sql)
- 掌握Oracle数据库监控要点,实现高效管理(oracle数据库监控点)
- 高效使用Oracle客户端,简单上手!(精简版oracle客户端)
- 使用在线Oracle服务器,实现最佳数据处理性能(在线oracle服务器)
- Oracle 临时变量的作用和使用方式(oracle临时变量吗)
- 使用yum工具轻松安装Oracle数据库(yum安装oracle)
- 函数Oracle数据库极大值函数MAX的使用(oracle使用max)
- Oracle传表参数的简单实现(oracle 传表参数)
- 语句使用Oracle中的IF语句控制流程(oracle 中的if)
- Oracle中异常处理的概念与实践(oracle中异常是什么)
- 不需要重装,Oracle使用维护更轻松(oracle不用重装)
- n展示Oracle EMN0N的未来(oracle emn0)