- Performance Tasks, Essential
- Materialized Views
- Install Oracle 18c Database Product
- Create 18c Database
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.