Oracle Server Response Test
This test is used to measure the request processing ability of the database server.
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 server 10g
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every Oracle server.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Avg. response time for queries: |
This measure indicates time taken by the Oracle server to process SQL queries and send the result-set back to the user. |
Secs |
Ideally, the value of this measure should be low. If this measure shows high value then you must check which event takes more time. The response time for SQL queries can also increase due to any of the following factors:
|
Avg. response time per transaction: |
Indicates the average time taken by the Oracle database server to process every transaction.
|
Secs |
Ideally, the value of this measure should be low. If this measure, records a high value then it indicates that the Oracle database server takes more time to respond to user transactions. We suggest that you identify the queries that are responsible for this, and fine-tune them for efficiency. |