Oracle10g Administration(002)

Planning for Database Creation

1:Plan the database tables and indexes and estimate the amount of space they will require.

2:Plan the layout of the underlying operating system files your database will comprise. Proper distribution of files can improve database performance dramatically by distributing the I/O during file access. You can distribute I/O in several ways when you install Oracle software and create your database. For example, you can place redo log files on separate disks or use striping. You can situate datafiles to reduce contention. And you can control data density (number of rows to a data block).

3:Consider using Oracle-managed files and Automatic Storage Management to create and manage the operating system files that make up your database storage.