|
Oracle9i introduces a new powerful
manageability feature called Oracle Managed Files (OMF.)
The main benefits of the Oracle Managed Files
are:
- Ease of Oracle file management
- Reduction of Oracle file management errors
- Disk space management improvments
- Easier third party application integration
The new OMF feature simplifies database administration
by eliminating the need for administrators to directly manage
the files of an Oracle database. This feature allows for specifying
operations in terms of database objects. Oracle uses the standard
operating system (OS) file system interfaces internally to create
and delete files as needed for tablespaces, online logs and
controlfiles. DBAs only need to specify the location of these
files using new initialization parameters. Oracle then ensures
creation of a file with a unique name and delete it when the
corresponding object is dropped.
OMF reduces errors caused by administrators
specifying incorrect file names, reduces disk space wasted
in obsolete files, and simplifies creation of test and development
databases. It also makes development of portable third party
applications easier since it eliminates the need to put OS
specific file names in SQL scripts.
While the parameter DB_CREATE_FILE_DEST specifies
the default location of datafiles, the parameter DB_CREATE_ONLINE_LOG_DEST_<n>,
where n is any integer between 1 and 5, decides the default
location for copies of online logs and controlfiles. If neither
of the last two parameters are set, all the files (datafiles,
controlfiles and online logs) will be created at the destination
specified by the DB_CREATE_FILE_DEST parameter. Oracle Managed
datafiles, created by default, will be 100 MB in size and
will be auto extensible with unlimited maximum size. The default
size of Oracle Managed online logs will also be 100MB.
More Info
Oracle9i
Database Daily Features
|
 |
Bookmark
