||Oracle Tips by Burleson
Chapter 10 - Ease of Administration
OCP Instructors Guide for
Oracle DBA Certification
Follow OFA Naming Conventions
OFA stands for Optimal Flexible Architecture.
The OFA standard is a set of naming conventions and configuration
Distributes I/O among different disk drives.
Facilitates ease of administration by creating
naming conventions for mountpoints, directories, file suffixes,
database binary directories and database output (i.e, background
dump, cored dump).
These standard naming conventions and placement
guidelines are intended to improve database performance by spreading
I/O, protect against drive failures and also allow administrators to
more easily assume the responsibility of supporting new database
environments. In addition, because OFA standards are well documented
by the Oracle Corporation, newly hired DBA and consultants are able
to more quickly assume administration responsibilities.
Administrative Support for the Application Development Process
One of the first sections of this booklet
provides information on database design reviews. Database design
review meetings foster effective communications between the DBA
unit, system support personnel and application developers throughout
the entire application design and implementation process. When
Oracle design issues are addressed early in the development
lifecycle, problems are minimized and the migration from test to
production is more easily accomplished.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
by Christopher T. Foot
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA