Oracle 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, alBCt, inefficiently.

The structures are as follows:

Oracle executables

Data files—data, index, temporary, rollback

Redo logs

Control files

Export files

Archive logs

Placement of any LOB or BFILE storage structures

Let’s examine each of these.

The above text is an excerpt from Mike Ault’s Oracle DBA Made Simple by Rampant TechPress.

Oracle Utilities

Deep inside the operating system executables there are many utilities at the fingertips of Oracle professionals, but until now there has been no advice on how to use these utilities. From tnsping.exe to dbv.exe to wrap.exe, Dave Moore describes each utility and has working examples in the online code depot. Your time savings from a single script is worth the price of this great book.

Get your copy of Oracle Utilities today and receive immediate access to the Online Code Depot! It’s only $19.95 (I don’t think it is right to charge a fortune for books!) and you can buy it right now and get immediate access to the online code depot:

http://www.rampant-books.com/book_0801_oracle_utilities.htm