DATAFILE I/O NOTES:

File Name - Datafile name

Physical Reads - Number of physical reads

Reads % - Percentage of physical reads

Physical Writes - Number of physical writes

Writes % - Percentage of physical writes

Total Block I/O's - Number of I/O blocks

When an Oracle instance is initially configured, the data and index configuration is determined based on analysis of best guess statistics. Once an application becomes production, it is very important to monitor the true disk activity. If the output reveals that the balance is not distributed properly, then it is the responsibility of the DBA to reconfigure the system to ensure proper balancing. Any time there is a significant imbalance; there will be overall system performance degradation.

Use this report to identify any "hot spots" and I/O contention