DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.V_$PERSISTENT_QUEUES

Object Details
Object Name: V_$PERSISTENT_QUEUES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUEUE_ID NUMBER

QUEUE_TABLE_ID NUMBER

QUEUE_SCHEMA VARCHAR2 (30)
QUEUE_NAME VARCHAR2 (30)
FIRST_ACTIVITY_TIME TIMESTAMP(6) (20)
ENQUEUED_MSGS NUMBER

DEQUEUED_MSGS NUMBER

BROWSED_MSGS NUMBER

ELAPSED_ENQUEUE_TIME NUMBER

ELAPSED_DEQUEUE_TIME NUMBER

ENQUEUE_CPU_TIME NUMBER

DEQUEUE_CPU_TIME NUMBER

AVG_MSG_AGE NUMBER

DEQUEUED_MSG_LATENCY NUMBER

ELAPSED_TRANSFORMATION_TIME NUMBER

ELAPSED_RULE_EVALUATION_TIME NUMBER

ENQUEUED_EXPIRY_MSGS NUMBER

ENQUEUED_DELAY_MSGS NUMBER

MSGS_MADE_EXPIRED NUMBER

MSGS_MADE_READY NUMBER

LAST_ENQUEUE_TIME TIMESTAMP(6) (20)
LAST_DEQUEUE_TIME TIMESTAMP(6) (20)
LAST_TM_EXPIRY_TIME TIMESTAMP(6) (20)
LAST_TM_READY_TIME TIMESTAMP(6) (20)
ENQUEUE_TRANSACTIONS NUMBER

DEQUEUE_TRANSACTIONS NUMBER

EXECUTION_COUNT NUMBER

OLDEST_MSGID RAW (16)
OLDEST_MSG_ENQTM TIMESTAMP(6) (20)
CON_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUEUE_ID
,      QUEUE_TABLE_ID
,      QUEUE_SCHEMA
,      QUEUE_NAME
,      FIRST_ACTIVITY_TIME
,      ENQUEUED_MSGS
,      DEQUEUED_MSGS
,      BROWSED_MSGS
,      ELAPSED_ENQUEUE_TIME
,      ELAPSED_DEQUEUE_TIME
,      ENQUEUE_CPU_TIME
,      DEQUEUE_CPU_TIME
,      AVG_MSG_AGE
,      DEQUEUED_MSG_LATENCY
,      ELAPSED_TRANSFORMATION_TIME
,      ELAPSED_RULE_EVALUATION_TIME
,      ENQUEUED_EXPIRY_MSGS
,      ENQUEUED_DELAY_MSGS
,      MSGS_MADE_EXPIRED
,      MSGS_MADE_READY
,      LAST_ENQUEUE_TIME
,      LAST_DEQUEUE_TIME
,      LAST_TM_EXPIRY_TIME
,      LAST_TM_READY_TIME
,      ENQUEUE_TRANSACTIONS
,      DEQUEUE_TRANSACTIONS
,      EXECUTION_COUNT
,      OLDEST_MSGID
,      OLDEST_MSG_ENQTM
,      CON_ID
FROM SYS.V_$PERSISTENT_QUEUES;

Dependencies

[top of page]

SYS.V_$PERSISTENT_QUEUES references the following:

SYS.V_$PERSISTENT_QUEUES is referenced by following:

SchemaPUBLIC
SynonymV$PERSISTENT_QUEUES