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

VIEW: SYS.INT$DBA_HIST_BUF_SUBSCRIBERS

Object Details
Object Name: INT$DBA_HIST_BUF_SUBSCRIBERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[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)
STARTUP_TIME DATE
Yes
LAST_BROWSED_SEQ NUMBER

LAST_BROWSED_NUM NUMBER

LAST_DEQUEUED_SEQ NUMBER

LAST_DEQUEUED_NUM NUMBER

CURRENT_ENQ_SEQ NUMBER

NUM_MSGS NUMBER

CNUM_MSGS NUMBER

TOTAL_DEQUEUED_MSG NUMBER

TOTAL_SPILLED_MSG NUMBER

EXPIRED_MSGS NUMBER

MESSAGE_LAG NUMBER

ELAPSED_DEQUEUE_TIME NUMBER

DEQUEUE_CPU_TIME NUMBER

LAST_DEQUEUE_TIME TIMESTAMP(3) (11)
OLDEST_MSGID RAW (16)
OLDEST_MSG_ENQTM TIMESTAMP(3) (11)
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
,      STARTUP_TIME
,      LAST_BROWSED_SEQ
,      LAST_BROWSED_NUM
,      LAST_DEQUEUED_SEQ
,      LAST_DEQUEUED_NUM
,      CURRENT_ENQ_SEQ
,      NUM_MSGS
,      CNUM_MSGS
,      TOTAL_DEQUEUED_MSG
,      TOTAL_SPILLED_MSG
,      EXPIRED_MSGS
,      MESSAGE_LAG
,      ELAPSED_DEQUEUE_TIME
,      DEQUEUE_CPU_TIME
,      LAST_DEQUEUE_TIME
,      OLDEST_MSGID
,      OLDEST_MSG_ENQTM
,      CON_DBID
,      CON_ID
FROM SYS.INT$DBA_HIST_BUF_SUBSCRIBERS;

Dependencies

[top of page]

SYS.INT$DBA_HIST_BUF_SUBSCRIBERS references the following:

SchemaSYS
ViewDBA_HIST_SNAPSHOT
TableWRH$_BUFFERED_SUBSCRIBERS
SYS.INT$DBA_HIST_BUF_SUBSCRIBERS is referenced by following:

SchemaSYS
ViewDBA_HIST_BUFFERED_SUBSCRIBERS