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

See Also:

“V$PERSISTENT_QUEUES”


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