This metric shows the number of messages in a persistent queue that are waiting to be dequeued by the apply process. The apply process has attempted to dequeue these messages at least once, and the apply process failed. The apply process might attempt to dequeue a waiting message again.
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 data source includes the following data dictionary views: DBA_QUEUES
, DBA_APPLY
, and AQ$queue_table_name
.
The messages in WAITING
might have been enqueued with a delay attribute set. In this case, after the specified delay period is finished, the messages will be ready to dequeue.
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.