Oracle教程 2023-02-24

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

本站中文解释

Oracle视图DBA_HIST_PERSISTENT_QUEUES用于查询 Oracle 数据库中持久性队列的统计信息。它显示了可用于跟踪每个持久性队列的每日性能指标，如排队、拥塞、等待和错误统计信息。可以用来分析分析队列的空载性能，系统扩容必要性，队列内消息错误和连接性能等。

使用该视图的方法如下：

1）查询持久性队列的历史数据:
SELECT * FROM DBA_HIST_PERSISTENT_QUEUES

2）获取指定持久性队列的消费者数和统计信息:
SELECT consumer_count, enqueues, dequeues, errors
FROM DBA_HIST_PERSISTENT_QUEUES
WHERE queue_name= ‘MyQueue’

3）按日期统计持久性队列的统计信息:
SELECT sample_time, consumer_count, enqueues, dequeues, errors
FROM DBA_HIST_PERSISTENT_QUEUES
WHERE queue_name= ‘MyQueue’
AND sample_time BETWEEN date1 AND date2

官方英文解释

DBA_HIST_PERSISTENT_QUEUES displays Oracle Database AQ persistent queues historical statistics information.

This view contains snapshots of V$PERSISTENT_QUEUES.

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`QUEUE_SCHEMA`	`VARCHAR2(128)`	`NOT NULL`	Owner of the queue
`QUEUE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the queue
`QUEUE_ID`	`NUMBER`	`NOT NULL`	Identifier for the queue
`FIRST_ACTIVITY_TIME`	`TIMESTAMP(6)`		First queue activity time since database startup
`ENQUEUED_MSGS`	`NUMBER`		Number of messages enqueued
`DEQUEUED_MSGS`	`NUMBER`		Number of messages dequeued Note: This column will not be incremented until all the subscribers of the message have dequeued the message and its retention time has elapsed.
`BROWSED_MSGS`	`NUMBER`		Number of messages that have been browsed
`ELAPSED_ENQUEUE_TIME`	`NUMBER`		Total time (in hundredths of a second) spent doing enqueue
`ELAPSED_DEQUEUE_TIME`	`NUMBER`		Total time (in hundredths of a second) spent doing dequeue
`ENQUEUE_CPU_TIME`	`NUMBER`		Total CPU time for enqueue (in hundredths of a second)
`DEQUEUE_CPU_TIME`	`NUMBER`		Total CPU time for dequeue (in hundredths of a second)
`AVG_MSG_AGE`	`NUMBER`		Average age of messages in the queue
`DEQUEUED_MSG_LATENCY`	`NUMBER`		Last dequeued message latency (in seconds)
`ELAPSED_TRANSFORMATION_TIME`	`NUMBER`		Total time (in hundredths of a second) spent doing transformation
`ELAPSED_RULE_EVALUATION_TIME`	`NUMBER`		Total time (in hundredths of a second) spent doing rule evaluation
`ENQUEUED_EXPIRY_MSGS`	`NUMBER`		Number of messages enqueued with expiry
`ENQUEUED_DELAY_MSGS`	`NUMBER`		Number of messages enqueued with delay
`MSGS_MADE_EXPIRED`	`NUMBER`		Number of messages expired by time manager
`MSGS_MADE_READY`	`NUMBER`		Number of messages made ready by time manager
`LAST_ENQUEUE_TIME`	`TIMESTAMP(6)`		Last message enqueue time
`LAST_DEQUEUE_TIME`	`TIMESTAMP(6)`		Last message dequeue time
`LAST_TM_EXPIRY_TIME`	`TIMESTAMP(6)`		Last time message was expired by time manager
`LAST_TM_READY_TIME`	`TIMESTAMP(6)`		Last time message was made ready by time manager
`ENQUEUE_TRANSACTIONS`	`NUMBER`		Number of enqueue transactions
`DEQUEUE_TRANSACTIONS`	`NUMBER`		Number of dequeue transactions
`EXECUTION_COUNT`	`NUMBER`		Number of executions of the dequeue cursor
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. 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

本站中文解释

官方英文解释

相关推荐