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 |
|---|---|---|
|
|
|
Current instance ID |
|
|
|
Queue ID |
|
|
|
Queue table object ID |
|
|
|
Queue schema name |
|
|
|
Queue name |
|
|
|
Current tuned size of the queue partition cache, expressed in number of partition cache elements |
|
|
|
Current number of cached partitions in the queue partition cache |
|
|
|
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 |
|
|
|
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 |
|
|
|
Total number of times a tune-up was triggered on the queue partition cache, since the cache was initialized |
|
|
|
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 |
|
|
|
Total number of times a tune-down was triggered on the queue partition cache, since the cache was initialized |
|
|
|
Total number of cache misses during partition lookups on the queue partition cache |
|
|
|
Total number of cache hits during partition lookups on the queue partition cache |
|
|
|
Total number of successful fetches from the queue partition cache |
|
|
|
Total number of caching operations that occurred on the queue partition cache |
|
|
|
Total number of times queue partitions were unbounded |
|
|
|
Current tuned size of the dequeue log partition cache, expressed in number of partition cache elements |
|
|
|
Current number of cached partitions in the dequeue log partition cache |
|
|
|
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 |
|
|
|
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 |
|
|
|
Total number of times a tune-up was triggered on the dequeue log partition cache, since the cache was initialized |
|
|
|
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 |
|
|
|
Total number of times a tune-down was triggered on the dequeue log partition cache, since the cache was initialized |
|
|
|
Total number of cache misses during partition lookups on the dequeue log partition cache |
|
|
|
Total number of cache hits during partition lookups on the dequeue log partition cache |
|
|
|
Total number of successful fetches from the dequeue log partition cache |
|
|
|
Total number of caching operations that occurred on the dequeue log partition cache |
|
|
|
Total number of times dequeue log partitions were unbounded |
|
|
|
Total number of queue partitions created inline during foreground AQ enqueue operations |
|
|
|
Total number of queue partitions created asynchronously by the AQ partitioning background process |
|
|
|
Total number of dequeue log partitions created inline during foreground AQ dequeue operations |
|
|
|
Total number of dequeue log partitions created asynchronously by the AQ partitioning background process |
|
|
|
Total number of truncated and recycled queue partitions |
|
|
|
Total number of truncated and recycled dequeue log partitions |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
