Oracle DataFile Activity Test
The average read and write time of Oracle metric is the amount of time spent for each read and write against the datafile. By comparing read and write times across multiple datafiles will show you which datafiles are slower than others and you can identify the hot files among them.
Note :
The test should be configured to run every 10 mins or more
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 datafile on the Oracle server.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Average read time: |
This measure indicates the average time taken to read each datafile.
|
Secs |
Disk read times might be high due to the following reasons.
Building efficient SQL queries can significantly increase the speed of your read operations. If fragmented data is the cause for the consistent slow-down in the read operations, then you might want to consider re-organizing the database objects to address this issue. |
Average write time: |
This measure indicates the average time taken to write each datafile. |
Secs |
|