Oracle Point, Oracle Life.

I just quickly tested two scripts about oracle database disk I/O tuning and found helpful. Those two scripts can be found at here.

To use those tow scripts well, I’m suggesting you to:

• run them at time of lightload to get the baseline of disk I/O
• run them at peaktime with heavyload to get the threshold of disk I/O
• periodically run them to get time-of-point measures

Note: I’ve test them on Oracle 10g only. And, I noticed that those two scripts may not good to run against oracle 9i because the following statistics are not collected or populated to view v$sysstat.

• physical read total IO requests
• physical write total IO requests
• physical read total multi block requests
• physical write total multi block requests
• physical read total bytes
• physical write total bytes

Also, you may need to log on as user with role sysdba because the sys-owned views need to be queried in running of those scripts.

Popularity: 4% [?]