||Oracle Tips by Burleson
Oracle OFA Structures and How They Affect
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
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.