Planning Database File Locations
Oracle advises that you distribute your database files in a way that facilitates performance and reliability.
At least two active copies of the database's control files should be kept on at least two different devices.
Redo log files should be multiplexed and each group of members be put on different disks.
Data files whose data will have different life spans (as in a data warehouse or read-only tablespaces versus an Online Transaction Processing system) should be distributed on different disks.
Data with different life spans (for example, application data and temporary sort data) should be separated into different tablespaces (and by extension into different datafiles) to minimize fragmentation.
Data with different ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
