There are several instance configuration features. Such as-
a. Database Configuration Assistant (DBCA)features:
The creation or configuration of a database using the DBCA in Oracle Database 10g automatically creates and implements a new, auxiliary system tablespace, SYSAUX, which supplements the SYSTEM database as a central location for the storage of database metadata. The flash recovery area is an optional disk location used to store files related to recovery, such as control file and online redo log copies, archived logs, and flashback logs. When the DBCA is used to create a database, it automatically creates the flash recovery area.
b. Policy-based database configuration framework:
Oracle Database 10g includes a stock set of recommended database policies, which can be disabled via the OEM Database Control interface. These policies aid database monitoring and administration by implementing a default set of best practices-the violation of which results in Warning or Critical alerts in the OEM Database Control.
c. Initialization parameters:
Basic initialization parameters, such as PROCESSES, SESSIONS, and CONTROL_FILES, are separated from more advanced parameters and defined automatically. Advanced parameters, such as CURSOR_SHARING, should be modified only to improve performance or troubleshoot problems.
