DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_HIST_PERSISTENT_SUBS

Object Details
Object Name: DBA_HIST_PERSISTENT_SUBS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

STREAMS AQ Persistent Queue Subscribers Historical Statistics Information

[View Source]

Columns
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

Query Text

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.DBA_HIST_PERSISTENT_SUBS;

Dependencies

[top of page]

SYS.DBA_HIST_PERSISTENT_SUBS references the following:

SchemaSYS
ViewINT$DBA_HIST_PERSISTENT_SUBS
SYS.DBA_HIST_PERSISTENT_SUBS is referenced by following:

SchemaPUBLIC
SynonymDBA_HIST_PERSISTENT_SUBS