Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_HIST_BUFFERED_QUEUES

DBA_HIST_BUFFERED_QUEUES displays historical information about all buffered queues available for the instance.

Column Datatype NULL Description
SNAP_ID NUMBER NOT NULL Unique snapshot ID
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Instance number for the snapshot
QUEUE_SCHEMA VARCHAR2(128) NOT NULL Owner of the queue
QUEUE_NAME VARCHAR2(128) NOT NULL Name of the queue
STARTUP_TIME DATE NOT NULL Startup time of the instance
QUEUE_ID NUMBER NOT NULL ID of the queue
NUM_MSGS NUMBER   Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk)
SPILL_MSGS NUMBER   Current number of overflow messages spilled to disk from the buffered queue
CNUM_MSGS NUMBER   Cumulative total number of messages enqueued into the buffered queue since the buffered queue was created.
CSPILL_MSGS NUMBER   Cumulative total number of overflow messages spilled to disk from the buffered queue since the buffered queue was created
EXPIRED_MSGS NUMBER   Number of expired messages
OLDEST_MSGID RAW(16)   Message ID of the oldest message
OLDEST_MSG_ENQTM TIMESTAMP(3)   Enqueue time of the oldest message
QUEUE_STATE VARCHAR2(25)   Indicates whether the queue is in recovery mode (QUEUE IS IN RECOVERY MODE) or not (NORMAL)
ELAPSED_ENQUEUE_TIME NUMBER   Total time spent in enqueue (in hundredths of a second)
ELAPSED_DEQUEUE_TIME NUMBER   Total time spent in dequeue (in hundredths of a second)
ELAPSED_TRANSFORMATION_TIME NUMBER   Total time for evaluating transformations (in hundredths of a second)
ELAPSED_RULE_EVALUATION_TIME NUMBER   Total time for rule evaluations (in hundredths of a second)
ENQUEUE_CPU_TIME NUMBER   Total CPU time for enqueue (in hundredths of a second)
DEQUEUE_CPU_TIME NUMBER   Total CPU time for dequeue (in hundredths of a second)
LAST_ENQUEUE_TIME TIMESTAMP(3)   Last message enqueue time
LAST_DEQUEUE_TIME TIMESTAMP(3)   Last message dequeue time
CON_DBID NUMBER   The database ID of the PDB for the sampled session
CON_ID NUMBER   The ID of the container that CON_DBID identifies. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data