[Home] [Help] [Dependency Information]
Object Name: | GV_$BUFFERED_PUBLISHERS |
---|---|
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) | ||
SENDER_NAME | VARCHAR2 | (30) | ||
SENDER_ADDRESS | VARCHAR2 | (1024) | ||
SENDER_PROTOCOL | NUMBER | |||
NUM_MSGS | NUMBER | |||
CNUM_MSGS | NUMBER | |||
LAST_ENQUEUED_MSG | NUMBER | |||
UNBROWSED_MSGS | NUMBER | |||
OVERSPILLED_MSGS | NUMBER | |||
MEMORY_USAGE | NUMBER | |||
ELAPSED_ENQUEUE_TIME | NUMBER | |||
ENQUEUE_CPU_TIME | NUMBER | |||
LAST_ENQUEUE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
PUBLISHER_STATE | VARCHAR2 | (59) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, QUEUE_ID
, QUEUE_SCHEMA
, QUEUE_NAME
, SENDER_NAME
, SENDER_ADDRESS
, SENDER_PROTOCOL
, NUM_MSGS
, CNUM_MSGS
, LAST_ENQUEUED_MSG
, UNBROWSED_MSGS
, OVERSPILLED_MSGS
, MEMORY_USAGE
, ELAPSED_ENQUEUE_TIME
, ENQUEUE_CPU_TIME
, LAST_ENQUEUE_TIME
, PUBLISHER_STATE
, CON_ID
FROM SYS.GV_$BUFFERED_PUBLISHERS;
|
|
|