Oracle 视图 DBA_HIST_CHANNEL_WAITS 官方解释，作用，如何使用详细说明

表

Oracle视图DBA_HIST_CHANNEL_WAITS是属于Oracle的性能分析视图，它显示channel操作的等待信息。所谓channel是指Oracle流传输服务（Oracle Streams）中用来收发消息的传输管道，也就是传输通道。

使用该视图可以帮助DBA检查当前系统中channel出现的等待事件。可以分析每个操作平均的等待时间、最长的等待时间等，从而找出导致等待的原因，进而寻找及解决等待事件的解决办法。

官方英文解释

DBA_HIST_CHANNEL_WAITS display the amount of messages broadcast on KSR and KSXR channels as well as the total time taken for the broadcast to complete.

KSR channels are local to an instance, that is, only processes within an instance subscribed to the channel can receive the message. KSXR channels allow messages to be broadcast across instances. The messages broadcast and the total time to broadcast are cumulative from the start of the instance. Channels with high overall average wait times could indicate potential problems with a subscriber on that channel which can lead to poor scaled performance.

The cumulative count of messages published on the channel (from instance startup)

The total number of times a publisher has waited for a broadcast to complete. This metric is only pertinent for asynchronous broadcasts where the broadcast can be dispatched and publisher can wait for completion at a later point of time. A high wait count along with increased wait time can indicate a potential performance bottleneck.

The cumulative amount of time in microseconds that publishers have waited for message broadcast to complete. Average time for broadcast on a channel can be computed by dividing WAIT_TIME_USEC by WAIT_COUNT. A high average time can indicate a potential performance bottleneck.

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.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_HIST_CHANNEL_WAITS 官方解释，作用，如何使用详细说明