This metric shows information about the number of messages enqueued by a capture process in a buffered queue. This number includes both messages in memory and messages spilled from memory.
If queue publishers other than the capture process enqueue messages into a buffered queue, then the values shown can include messages from these other queue publishers.
The rest of the information in this section is only valid for this metric when it appears in either the Enterprise Manager Grid Control or the Enterprise Manager Database Control (if applicable).
The following table shows how often the metric's value is collected.
Target Version |
Collection Frequency |
10.1.0.x; 10.2.0.x; 11.1.0.x; 11.2.0.x |
Every 5 Minutes |
The NUM_MSGS
column in the following query shows this metric for a capture process:
SELECT CAPTURE_NAME, P.NUM_MSGS NUM_MSGS, Q.SPILL_MSGS SPILL_MSGS FROM V$BUFFERED_PUBLISHERS P, V$BUFFERED_QUEUES Q, DBA_CAPTURE C WHERE C.QUEUE_NAME = P.QUEUE_NAME AND C.QUEUE_OWNER = P.QUEUE_SCHEMA AND C.QUEUE_NAME = Q.QUEUE_NAME AND C.QUEUE_OWNER = Q.QUEUE_SCHEMA AND C.CAPTURE_NAME = P.SENDER_NAME AND P.SENDER_ADDRESS IS NULL AND P.SENDER_PROTOCOL = 1;
When a capture process is enabled, monitor this metric to ensure that the capture process enqueuing messages.
Related Topics
About Alerts
About the Metric Detail Page
Editing Thresholds
Understanding Line Charts
Streams Capture Process
Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.