Database Configuration Assistant (DBCA) Enhancements
Using the DBCA ensures that DBA is reminded about
all the important options, rather than needing to remember them and
perform them all manually. Following are some of the DBCA
enhancements:
1. The SYSAUX Tablespace: This is a new
tablespace introduced in Oracle 10g used as a central location
for the metadata of all tools like the OEM and RMAN.
2. Flash Recovery Area: This is a unified
storage location on your server that Oracle reserves exclusively
for all database recovery-related files and activities.
3. Automatic Storage Management (ASM)
4. Management Options: like alert notification,
job scheduling, and software management.
Policy-Based Database Configuration Framework
Oracle 10g enables you to monitor all of your
databases to see if there are any violations of the predetermined
configuration policies. This can be managed in the Database
Control using following sections:
o Diagnostic Summary: shows you if there are any
policy violations anywhere
o Policy Violations: summarizes all policy
violations in your databases and hosts.
o Manage Policy Library: to disable any policy.
Simplified Initialization Parameters
• Basic initialization parameters: This set
consists of about 25 to 30 of the most common parameters that you
need for an Oracle database.
• Advanced initialization parameters: These
are parameters you’ll need to deploy only rarely, to improve your
database’s performance or to overcome some special performance
problems.
Changes in the Initialization Parameters -
Deprecated Parameters
Irreversible Datafile Compatibility
The minimum value of the COMPATIBLE initialization
parameter is 9.2.0. The default value, however, is 10.0.0. If value
of the parameter was 10.0.0, this means that you won’t be able to
downgrade the Oracle 10g database to a prior release; the datafile
is irreversible.
The ALTER DATABASE RESET COMPATIBILITY command is
obsolete in Oracle 10g.
