| |
 |
|
Donald K. Burleson
Oracle Tips |
Minimum Oracle OFA Configuration
The
minimum suggested configuration would consist of seven data areas:
disks, striped sets, RAID sets, or whatever else comes down the pike
in the next few years. These areas should be as separate as
possible, ideally operating off of different device controllers or
channels to maximize throughput. The more disk heads you have moving
at one time, the faster your database will be. The disk layout
should minimize disk contention. For example:
AREA1. Oracle executables and user areas, a control file, the SYSTEM
tablespace, redo logs
AREA2. Data-datafiles, a control file, tool-datafiles, redo logs
AREA3. Index-datafiles, a control file, redo logs
AREA4. Rollback segment-datafiles
AREA5. Archive log files
AREA6. Export files
AREA7. Backup staging
Of course, this is just a start; you might find it wise to add more
areas to further isolate large or active tables into their own areas
as well as to separate active index areas from each other.
The structure on UNIX could look like the following:
/oracle0/product/oracle/9.0.1/ Top level $ORACLE_HOME
bin/ Standard distribution structure under version
doc/
rdbms/
...
This is an
excerpt by Mike Ault’s book “Oracle
Administration & Management”. If you want more current Oracle tips
by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or
Ault’s Oracle Scripts Download.
|
