Most Popular

Database Best Practice

Ensure Your Disk I\O Performance is Adequate

Ideally Oracle requires 1ms read and 5ms average write times or better for production environments. If your SAN or RAID system cannot achieve this your clients will experience degraded performance and perhaps loss of service events. Make sure those that make decisions on Oracle database hardware purchases know this. Never assume your disk I/O is OK because it is new hardware. Security infrastructure, caching, disk controllers, encryption can all factor in in influencing this.

For more Oracle articles and best practices go here.