This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.
This metric represents the percentage of time spent waiting, database-wide, for resources or objects during this sample period.
This test checks the percentage time spent waiting, database-wide, for resources or objects during this sample period. If the % Wait Time is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.
DeltaTotalWait / (DeltaTotalWait + DeltaCpuTime) where:
DeltaTotalWait: Difference of 'sum of time waited for all wait events in v$system_event' between sample end and start.
DeltaCpuTime: Difference of 'select value from v$sysstat where name='CPU used by this session' between sample end and start.
Investigate further into which specific wait events are responsible for the bulk of the wait time. Individual wait events may identify unique problems within the database. Diagnosis will be tailored where appropriate through drilldowns specific to individual wait events.
Related Topics
About Alerts
About the Metric Detail Page
Editing Thresholds
Understanding Line Charts
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.