Oracle Internal Arch. (contd)
Optimal flexible architecture :
- characterize each tablespace with respect to segment growth pattern, I/O loads, administrative requirements, etc.
- segments with short life spans not to be put in same TS as permanent objects.
- separate static data (read-only) and volatile data into different tablespaces.
- separate sequentially scanned & randomly accessed tables into different tablespaces.
- objects having high I/O should be separated from those accessed less frequently.