v$queue

V$QUEUE contains information on the shared server message queues.

这个视图包括了共享服务器的消息队列

SQL> desc v$queue

Name Null? Type

----------------------------------------- -------- ----------------------------

PADDR RAW(8)

TYPE VARCHAR2(10)

QUEUED NUMBER

WAIT NUMBER

TOTALQ NUMBER

PADDR :所属队列的进程地址

TYPE:队列类型两种COMMON - Processed by servers和 DISPATCHER调度

QUEUED:在队列里面项目的数量
WAIT:total time that all items in this queue have waited (in hundredths of a second). Divide byTOTALQ for average wait per item.

TOTALQ:Total number of items that have ever been in the queue

ITPub博客

v$queue 视图