[Home] [Help] [Dependency Information]
Object Name: | GV_$AQ_SUBSCRIBER_LOAD |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
QUEUE_ID | NUMBER | |||
QUEUE_SCHEMA | VARCHAR2 | (30) | ||
QUEUE_NAME | VARCHAR2 | (30) | ||
SUBSCRIBER_ID | NUMBER | |||
SUBSCRIBER_NAME | VARCHAR2 | (30) | ||
LATENCY_STATE | VARCHAR2 | (8) | ||
LATENCY | NUMBER | |||
DEQUEUE_REQUESTS | NUMBER | |||
ACTIVE_SHARDS | NUMBER | |||
ACTIVE_LISTENER | VARCHAR2 | (5) | ||
FLAGS | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, QUEUE_ID
, QUEUE_SCHEMA
, QUEUE_NAME
, SUBSCRIBER_ID
, SUBSCRIBER_NAME
, LATENCY_STATE
, LATENCY
, DEQUEUE_REQUESTS
, ACTIVE_SHARDS
, ACTIVE_LISTENER
, FLAGS
, CON_ID
FROM SYS.GV_$AQ_SUBSCRIBER_LOAD;
|
|
|