[Home] [Help] [Dependency Information]
Object Name: | GV_$PERSISTENT_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) | ||
PUBLISHER_NAME | VARCHAR2 | (30) | ||
PUBLISHER_ADDRESS | VARCHAR2 | (1024) | ||
PROTOCOL | NUMBER | |||
ENQUEUED_MSGS | NUMBER | |||
ELAPSED_ENQUEUE_TIME | NUMBER | |||
ENQUEUE_CPU_TIME | NUMBER | |||
LAST_ENQUEUE_TIME | TIMESTAMP(6) | (20) | ||
ENQUEUE_TRANSACTIONS | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, QUEUE_ID
, QUEUE_SCHEMA
, QUEUE_NAME
, PUBLISHER_NAME
, PUBLISHER_ADDRESS
, PROTOCOL
, ENQUEUED_MSGS
, ELAPSED_ENQUEUE_TIME
, ENQUEUE_CPU_TIME
, LAST_ENQUEUE_TIME
, ENQUEUE_TRANSACTIONS
, CON_ID
FROM SYS.GV_$PERSISTENT_PUBLISHERS;
|
|
|