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

本站中文解释

V$AQ_PARTITION_STATS是Oracle提供的一个动态视图,用于报告单个队列分区的性能统计信息,也就是每个队列分区的统计数据结构,可以帮助我们更快更好地管理和维护我们的队列。

该视图的用途是帮助分析使用Oracle队列的应用程序,以更好地理解其行为。例如,可以使用V$AQ_PARTITION_STATS查看收到哪些消息,提交了哪些消息,消息大小是多少等等,以帮助调试性能问题或其他问题。

使用该视图的方法是,可以使用SELECT语句查询该视图的参数,从而查看队列的性能数据。例如,可以查询队列分区在某段时间内接收和发送的消息数,可以使用以下代码:SELECT queued_msg_count FROM V$AQ_PARTITION_STATS WHERE enqueue_time > some_time AND dequeue_time

官方英文解释

V$AQ_PARTITION_STATS displays usage statistics for the queue partition cache and the dequeue log partition cache.

Note:

AQ sharded queues are deprecated in Oracle Database 21c. Oracle recommends that you instead use Transactional Event Queues (TEQs) for higher throughput and better performance.

Column Datatype Description

INST_ID

NUMBER

Current instance ID

QUEUE_ID

NUMBER

Queue ID

QUEUE_TABLE_ID

NUMBER

Queue table object ID

QUEUE_SCHEMA

VARCHAR2(128)

Queue schema name

QUEUE_NAME

VARCHAR2(128)

Queue name

PT_TUNED_SIZ_QT

NUMBER

Current tuned size of the queue partition cache, expressed in number of partition cache elements

PT_CACHED_PTNS_QT

NUMBER

Current number of cached partitions in the queue partition cache

PT_OVER_CACHED_PTNS_QT

NUMBER

Current number of over-cached partitions in the queue partition cache, that is, the number of cached partitions whose partition cache elements exceed the current tuned size of the queue partition cache

PT_TOTAL_UPTUNE_QT

NUMBER

Total amount of space added to the queue partition cache due to tune-ups, since the cache was initialized, expressed in number of partition cache elements

PT_NO_OF_UPTUNES_QT

NUMBER

Total number of times a tune-up was triggered on the queue partition cache, since the cache was initialized

PT_TOTAL_DOWNTUNE_QT

NUMBER

Total amount of space removed from the queue partition cache due to tune-downs, since the cache was initialized, expressed in number of partition cache elements

PT_NO_OF_DOWNTUNES_QT

NUMBER

Total number of times a tune-down was triggered on the queue partition cache, since the cache was initialized

PT_CACHE_MISS_QT

NUMBER

Total number of cache misses during partition lookups on the queue partition cache

PT_CACHE_HIT_QT

NUMBER

Total number of cache hits during partition lookups on the queue partition cache

PT_TOTAL_CACH_GET_QT

NUMBER

Total number of successful fetches from the queue partition cache

PT_TOTAL_CACH_PUT_QT

NUMBER

Total number of caching operations that occurred on the queue partition cache

PT_UNBOUNDINGS_QT

NUMBER

Total number of times queue partitions were unbounded

PT_TUNED_SIZ_DQ

NUMBER

Current tuned size of the dequeue log partition cache, expressed in number of partition cache elements

PT_CACHED_PTNS_DQ

NUMBER

Current number of cached partitions in the dequeue log partition cache

PT_OVER_CACHED_PTNS_DQ

NUMBER

Current number of over-cached partitions in the dequeue log partition cache, that is, the number of cached dequeue log partitions whose partition cache elements exceed the current tuned size of the dequeue log partition cache

PT_TOTAL_UPTUNE_DQ

NUMBER

Total amount of space added to the dequeue log partition cache due to tune-ups, since the cache was initialized, expressed in number of partition cache elements

PT_NO_OF_UPTUNES_DQ

NUMBER

Total number of times a tune-up was triggered on the dequeue log partition cache, since the cache was initialized

PT_TOTAL_DOWNTUNE_DQ

NUMBER

Total amount of space removed from the dequeue log partition cache due to tune-downs, since the cache was initialized, expressed in number of partition cache elements

PT_NO_OF_DOWNTUNES_DQ

NUMBER

Total number of times a tune-down was triggered on the dequeue log partition cache, since the cache was initialized

PT_CACHE_MISS_DQ

NUMBER

Total number of cache misses during partition lookups on the dequeue log partition cache

PT_CACHE_HIT_DQ

NUMBER

Total number of cache hits during partition lookups on the dequeue log partition cache

PT_TOTAL_CACH_GET_DQ

NUMBER

Total number of successful fetches from the dequeue log partition cache

PT_TOTAL_CACH_PUT_DQ

NUMBER

Total number of caching operations that occurred on the dequeue log partition cache

PT_UNBOUNDINGS_DQ

NUMBER

Total number of times dequeue log partitions were unbounded

ADD_PARTITION_FG_QT

NUMBER

Total number of queue partitions created inline during foreground AQ enqueue operations

ADD_PARTITION_BG_QT

NUMBER

Total number of queue partitions created asynchronously by the AQ partitioning background process

ADD_PARTITION_FG_DQLOG

NUMBER

Total number of dequeue log partitions created inline during foreground AQ dequeue operations

ADD_PARTITION_BG_DQLOG

NUMBER

Total number of dequeue log partitions created asynchronously by the AQ partitioning background process

TRUNC_PARTITION_QT

NUMBER

Total number of truncated and recycled queue partitions

TRUNC_PARTITION_DQLOG

NUMBER

Total number of truncated and recycled dequeue log partitions

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 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.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$AQ_PARTITION_STATS 官方解释,作用,如何使用详细说明