| |
 |
|
Donald K. Burleson
Oracle Tips |
Oracle OFA Structures and
How They Affect Installation
As can be seen from the previous
section, an Oracle database is not a simple construct. Much thought
must go into file placement, size, number of control files, and
numerous other structural issues before installation. It is a
testament to the resiliency of the Oracle RDBMS that even if most of
the decisions are made incorrectly, the database that results will
still function, albeit, inefficiently.
The structures are as follows:
* Oracle executables
* Datafiles—data, index, temporary, rollback
* Redo logs
* Control files
* Export files
* Archive logs
* Placement of any large object (LOB) or BFILE storage structures
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.

|