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

VIEW: SYS.CDB_HIST_BUFFERED_QUEUES

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

STREAMS Buffered Queues Historical Statistics Information in all containers

[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
STARTUP_TIME DATE
Yes
QUEUE_ID NUMBER
Yes
NUM_MSGS NUMBER

SPILL_MSGS NUMBER

CNUM_MSGS NUMBER

CSPILL_MSGS NUMBER

EXPIRED_MSGS NUMBER

OLDEST_MSGID RAW (16)
OLDEST_MSG_ENQTM TIMESTAMP(3) (11)
QUEUE_STATE VARCHAR2 (25)
ELAPSED_ENQUEUE_TIME NUMBER

ELAPSED_DEQUEUE_TIME NUMBER

ELAPSED_TRANSFORMATION_TIME NUMBER

ELAPSED_RULE_EVALUATION_TIME NUMBER

ENQUEUE_CPU_TIME NUMBER

DEQUEUE_CPU_TIME NUMBER

LAST_ENQUEUE_TIME TIMESTAMP(3) (11)
LAST_DEQUEUE_TIME TIMESTAMP(3) (11)
CON_DBID NUMBER

CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      QUEUE_SCHEMA
,      QUEUE_NAME
,      STARTUP_TIME
,      QUEUE_ID
,      NUM_MSGS
,      SPILL_MSGS
,      CNUM_MSGS
,      CSPILL_MSGS
,      EXPIRED_MSGS
,      OLDEST_MSGID
,      OLDEST_MSG_ENQTM
,      QUEUE_STATE
,      ELAPSED_ENQUEUE_TIME
,      ELAPSED_DEQUEUE_TIME
,      ELAPSED_TRANSFORMATION_TIME
,      ELAPSED_RULE_EVALUATION_TIME
,      ENQUEUE_CPU_TIME
,      DEQUEUE_CPU_TIME
,      LAST_ENQUEUE_TIME
,      LAST_DEQUEUE_TIME
,      CON_DBID
,      CON_ID
FROM SYS.CDB_HIST_BUFFERED_QUEUES;

Dependencies

[top of page]

SYS.CDB_HIST_BUFFERED_QUEUES does not reference any database object

SYS.CDB_HIST_BUFFERED_QUEUES is referenced by following:

SchemaPUBLIC
SynonymCDB_HIST_BUFFERED_QUEUES