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

本站中文解释

Oracle视图V$EQ_MESSAGE_CACHE_ADVICE提供了对Event Message Cache的详细情况分析，例如最大的CACHE_HITS，优先期最长的HIT_CNT，缓存命中率CACHE_HIT_RATE等。 该视图也可以显示当前时刻系统保持的活动消息和查询的消息。

使用方法：

1、查询Event Message Cache的分析监控信息：

SELECT message_type, sum(hits) cache_hits, max(hit_cnt) longest_hit_cnt, round(cpu_hits/hits,2) async_cpu_ratio, round((hits-cpu_hits)/hits*100,2) cache_hit_rate FROM v$eq_message_cache_advice GROUP BY message_type;

2、查询当前正在进行的消息:

SELECT message_type, message_text, holder_name, object_name, object_type, decode(status, EXECUTING , USER_ACTIVE , QUEUED ) status FROM v$eq_message_cache_advice WHERE status IN ( EXECUTING , QUEUED );

官方英文解释

V$EQ_MESSAGE_CACHE_ADVICE shows simulated metrics for a range of potential message cache sizes for Transactional Event Queues (TEQs). This view assists in cache sizing by providing information in the form of metrics as described below.

MINIMUM: This cache size is required to have all dequeues in-memory (no uncached).

Estimated number of event stream partitions getting unevicted by foreground processes

Estimated number of event stream partitions getting unevicted by background processes

Simulated average time to evict a cached event stream partition (in milliseconds)

Simulated average time to unevict a cached event stream partition (in milliseconds)

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.

Oracle Database Advanced
Queuing User s Guide for more information about Oracle Transactional Event Queues and Advanced Queuing

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

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