[Home] [Help] [Dependency Information]
Object Name: | CDB_HIST_PERSISTENT_SUBS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
STREAMS AQ Persistent Queue Subscribers Historical Statistics Information in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
QUEUE_SCHEMA | VARCHAR2 | (128) | Yes | |
QUEUE_NAME | VARCHAR2 | (128) | Yes | |
SUBSCRIBER_ID | NUMBER | Yes | ||
SUBSCRIBER_NAME | VARCHAR2 | (128) | ||
SUBSCRIBER_ADDRESS | VARCHAR2 | (1024) | ||
SUBSCRIBER_TYPE | VARCHAR2 | (128) | ||
FIRST_ACTIVITY_TIME | TIMESTAMP(6) | (11) | ||
ENQUEUED_MSGS | NUMBER | |||
DEQUEUED_MSGS | NUMBER | |||
AVG_MSG_AGE | NUMBER | |||
BROWSED_MSGS | NUMBER | |||
EXPIRED_MSGS | NUMBER | |||
DEQUEUED_MSG_LATENCY | NUMBER | |||
LAST_ENQUEUE_TIME | TIMESTAMP(6) | (11) | ||
LAST_DEQUEUE_TIME | TIMESTAMP(6) | (11) | ||
ELAPSED_DEQUEUE_TIME | NUMBER | |||
DEQUEUE_CPU_TIME | NUMBER | |||
DEQUEUE_TRANSACTIONS | NUMBER | |||
EXECUTION_COUNT | NUMBER | |||
CON_DBID | NUMBER | |||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, QUEUE_SCHEMA
, QUEUE_NAME
, SUBSCRIBER_ID
, SUBSCRIBER_NAME
, SUBSCRIBER_ADDRESS
, SUBSCRIBER_TYPE
, FIRST_ACTIVITY_TIME
, ENQUEUED_MSGS
, DEQUEUED_MSGS
, AVG_MSG_AGE
, BROWSED_MSGS
, EXPIRED_MSGS
, DEQUEUED_MSG_LATENCY
, LAST_ENQUEUE_TIME
, LAST_DEQUEUE_TIME
, ELAPSED_DEQUEUE_TIME
, DEQUEUE_CPU_TIME
, DEQUEUE_TRANSACTIONS
, EXECUTION_COUNT
, CON_DBID
, CON_ID
FROM SYS.CDB_HIST_PERSISTENT_SUBS;
SYS.CDB_HIST_PERSISTENT_SUBS does not reference any database object
SYS.CDB_HIST_PERSISTENT_SUBS is referenced by following:
|
|
|