Oracle Sql Wait Events Test
This test monitors wait events generated by SQL queries, reveals the total number of such events and the their total wait time. The test additionally supports a detailed diagnosis capability, which when enabled, helps administrators identify the exact SQL query that has generated a time-consuming wait event. Using this information, administrators can easily fine-tune that query alone and make sure that such wait events do not recur.
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 class generating one/more SQL wait events on the Oracle server.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Average time waited by SQL: |
Indicates the average time the SQL queries waited during this measurement period. |
Secs |
If this measure registers a high value, then you use the detailed diagnosis of this measure to nail the time-consuming SQL query. |
Number of SQL wait events: |
Indicates the number of the SQL wait events under this wait class during this measurement period. |
Number |
|