The reader server for an apply process dequeues messages from the queue. The reader server computes dependencies between LCRs and assembles messages into transactions. The reader server then returns the assembled transactions to the coordinator, which assigns them to idle apply servers.
This metric shows the total number of messages dequeued by the reader server for the apply process since the last time the apply process was started.
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 |
All Versions |
Every 5 Minutes |
The TOTAL_MESSAGES_DEQUEUED
column in the following query shows this metric for an apply process:
SELECT APPLY_NAME, TOTAL_MESSAGES_DEQUEUED FROM V$STREAMS_APPLY_READER;
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 Components
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.