Every production environment needs to be built according to this standard:
The formula for database location on the frame is 20%-40%-20%-20%:
- 20% of the disk located on the external cylinder is the best performing area of the frame, to be used by online redo logs, undo segments, temp segments and most accessed database files
- 40% near the external cylinder is a good performing area, to be used by all other database files
- Next 20% is a slow performing area and should not be used for database files, except parameter files, archived logs, software install
- Last 20% correspond to the inner cylinder, is the slowest performing area and should not be used for database files at all.