[Home] [Help]
select "QUEUE_ID","QUEUE_SCHEMA","QUEUE_NAME","SUBSCRIBER_ID","SUBSCRIBER_NAME","LATENCY_STATE","LATENCY","DEQUEUE_REQUESTS","ACTIVE_SHARDS","ACTIVE_LISTENER","FLAGS","CON_ID" from v$aq_subscriber_load
SELECT "QUEUE_ID"
, "QUEUE_SCHEMA"
, "QUEUE_NAME"
, "SUBSCRIBER_ID"
, "SUBSCRIBER_NAME"
, "LATENCY_STATE"
, "LATENCY"
, "DEQUEUE_REQUESTS"
, "ACTIVE_SHARDS"
, "ACTIVE_LISTENER"
, "FLAGS"
, "CON_ID"
FROM V$AQ_SUBSCRIBER_LOAD
|
|
|
|