Oracle 视图 V$EQ_PARTITION_STATS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$EQ_PARTITION_STATS是Oracle数据库中包含有关每个表空间元数据分区统计信息的视图。该视图可以通过查询来使用，允许找到有关每个表空间元数据分区的相关信息，如果有多个表空间存在，这些表空间元数据分区可以组合成一个分区。
V$EQ_PARTITION_STATS视图主要用于监控表空间状态、规划表空间使用、计算表空间使用率和优化表空间空间的使用。它可以帮助用户确定当前表空间的性能，分析表空间的当前、历史和未来的使用情况，以及表空间中可能存在的不必要的资源浪费问题。
官方英文解释
V$EQ_PARTITION_STATS displays usage statistics for the Transactional Event Queue (TEQ) queue partition cache and the dequeue log partition cache.
| 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:
|
Note:
This view is available starting with Oracle Database 21c.
See Also:
Oracle Database Advanced
Queuing User’s Guide for more information about Oracle Transactional Event Queues and Advanced Queuing
