Oracle System Wait Events Test
This test monitors system wait classes for the number and average time of system wait events. Using this test, administrators can nail the wait class on which the Oracle server spends more time and why, so that performance tuning decisions can be taken.
This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Target of the test : An Oracle 10g server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every system wait class on the Oracle server.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Average time waited: |
Indicates the average time in seconds for each wait event in this class, during this measurement period.
|
Secs |
If the value of this measure is unusually high, then you can get the identify time-consuming wait event, using the detailed diagnosis of this measure. |
Number of system wait events: |
This measure indicates the number of waits for each wait class during this measurement period. |
Number |
|