This metric shows information about the number of messages in a buffered queue to be dequeued by the apply process. This number includes both messages in memory and messages spilled from memory.
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 an apply process:
SELECT APPLY_NAME, S.NUM_MSGS NUM_MSGS, Q.SPILL_MSGS SPILL_MSGS FROM DBA_APPLY A, V$BUFFERED_QUEUES Q,V$BUFFERED_SUBSCRIBERS S WHERE A.QUEUE_NAME = S.QUEUE_NAME AND A.QUEUE_OWNER = S.QUEUE_SCHEMA AND A.QUEUE_NAME = Q.QUEUE_NAME AND A.QUEUE_OWNER = Q.QUEUE_SCHEMA AND S.SUBSCRIBER_ADDRESS IS NULL;
When an apply process is enabled, monitor this metric to ensure that the apply process is dequeuing messages.
Related Topics
About Alerts
About the Metric Detail Page
Editing Thresholds
Understanding Line Charts
Streams Apply 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.