4.300 DBA_HIST_BUFFERED_SUBSCRIBERS
DBA_HIST_BUFFERED_SUBSCRIBERS
displays historical information about the subscribers for all buffered queues in the instance.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Owner of the queue |
|
|
|
Name of the queue |
|
|
|
Internal subscriber number (for identification) |
|
|
|
Name of the subscriber |
|
|
|
Address of the subscribing agent |
|
|
|
Type of subscriber:
|
|
|
|
Startup time of the instance |
|
|
|
Sequence number of the most recently browsed message for the subscriber (comparable to the number of messages in the |
|
|
|
Internal Message number for the most recently browsed message for the subscriber |
|
|
|
Sequence number of the most recently dequeued message for the subscriber (comparable to the number of messages in the |
|
|
|
Internal Message number for the most recently dequeued message for the subscriber |
|
|
|
Current sequence number of the most recently enqueued message for the subscriber |
|
|
|
Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk) |
|
|
|
Cumulative total number of messages enqueued for the subscriber since the creation of the buffered queue |
|
|
|
Total number of messages dequeued by the subscriber |
|
|
|
Total number of spilled messages for the subscriber |
|
|
|
Number of expired messages |
|
|
|
Message lag of the subscriber |
|
|
|
Total time spent in dequeue (in hundredths of a second) |
|
|
|
Total CPU time for dequeue (in hundredths of a second) |
|
|
|
Last message dequeue time |
|
|
|
Message ID of the oldest message |
|
|
|
Enqueue time of the oldest message |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|