Server Configuration in Oracle Database 10g

Oracle 10g includes some changes relating to basic server configuration including:

• Basic Initialization Parameters
• Cloning Databases Using DBCA
• Database Usage Statistics

Basic Initialization Parameters

The following parameter are now known as basic parameters and for the most part they are the only ones you should need to adjust:

• CLUSTER_DATABASE
• COMPATIBLE
• CONTROL_FILES
• DB_BLOCK_SIZE
• DB_CREATE_FILE_DEST
• DB_CREATE_ONLINE_LOG_DEST_n
• DB_DOMAIN
• DB_NAME
• DB_RECOVERY_FILE_DEST
• DB_RECOVERY_FILE_DEST_SIZE
• DB_UNIQUE_NAME
• INSTANCE_NUMBER
• JOB_QUEUE_PROCESSES
• LOG_ARCHIVE_DEST_n
• LOG_ARCHIVE_DEST_STATE_n
• NLS_LANGUAGE
• NLS_TERRITORY
• OPEN_CURSORS
• PGA_AGGREGATE_TARGET
• PROCESSES
• REMOTE_LISTENER
• REMOTE_LOGIN_PASSWORDFILE
• ROLLBACK_SEGMENTS
• SESSIONS
• SGA_TARGET
• SHARED_SERVERS
• STAR_TRANSFORMATION_ENABLED
• UNDO_MANAGEMENT
• UNDO_TABLESPACE

All other parameters are considered advanced and their default values should be left unchanged unless you have a specific reason to alter them.

When upgrading from 9i to 10g the compatible parameter should be set to 9.2.0. All of the new feature will only be available when the parameter is set to 10.0.0 or higher and the instance restarted. Once an instance has been restarted with a compaticble value of 10.0.0 it can never be set back to 9.x.

Cloning Databases Using DBCA

The "Template Management" section of the Database Configuration Assistant (DBCA) can be used to clone databases. The following method creates a clone of and existing database including both the structure and the data.

• Start the Database Configuration Assistant (DBCA).
• On the "Welcome" screen click the "Next" button.
• On the "Operations" screen select the "Manage Templates" option and click the "Next" button.
• On the "Template Management" screen select the "Create a database template" option and select the "From and existing database (structure as well as data)" sub-option then click the "Next" button.
• On the "Source database" screen select the relevant database instance and click the "Next" button.
• On the "Template properties" screen enter a suitable name and description for the template, confirm the location for the template files and click the "Next" button.
• On the "Location of database related files" screen choose either to maintain the file locations or to convert to OFA structure (recommended) and click the "Finish" button.
• On the "Confirmation" screen click the "OK" button.
• Wait while the Database Configuration Assistant progress screen gathers information about the source database, backs up the database and creates the template.

By default the template files are located in the "$ORACLE_HOME/assistants/dbca/templates" directory.

Database Usage Statistics

Two new views have been added in Oracle 10g which allow you to monitor database usage statistics:

• DBA_HIGH_WATER_MARK_STATISTICS - Displays high waternmark statistics (db_usage_hwm.sql).
• DBA_FEATURE_USAGE_STATISTICS - Displays database feature usage statistics (feature_usage.sql).

Alternatively this information can be viewed in Enterprise Manager (Administration > Database Usage Statistics). The page gives you access to both types of usage statistics.

For more information see:

• Oracle Database Reference 10g Release 1 (10.1)
• Creating Templates Using DBCA

Hope this helps. Regards Tim...

Back to the Top.

Back to normal view: https://oracle-base.com/articles/10g/server-configuration-10g