OPTIMAL STORAGE CONFIGURATION MADE EASY
Juan Loaiza · 2000
Configuring storage subsystems for the Oracle database is an unnecessarily complex process. In the conventional methodology, a storage configuration is custom designed for each site based on detailed knowledge of the application. This methodology assigns a specific load to various subsets of the database such as log files, rollback segments, index tablespaces, data tablespaces, etc. and assigns disks to these subsets based on their load profile. Many tradeoffs must be made when designing a storage configuration using this methodology. If an IO estimate or assignment is incorrect then performance can suffer. This methodology also requires ongoing load balancing as the database grows and the application is modified.