Oracle Object Wait Events Test
This test monitors wait events on objects, and accurately reveals which objects have been waiting for too long a time, and which wait event was active on that object during those times.
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 database server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every wait event on the Oracle server being monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Average wait time of objects |
Indicates the average time this object has waited. |
Secs |
Ideally, the value of this measure should be low. If this measure shows high value, then by making use of detailed diagnosis you can find the name of the wait event, the total number of waits, the total time waited, and the average wait time per event. With the help of such data you can identify those objects with a high wait time; such objects naturally are resource-intensive. To reduce the resource drain induced by the object, you need to make sure that accesses to the object are low on wait time. This can be ensured by employing the following techniques:
|
Number of object wait events : |
Indicates the number of the object waits for each event. |
Number |
|