8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Server Configuration in Oracle Database 10g
Oracle 10g includes some changes relating to basic server configuration including:
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:
Hope this helps. Regards Tim...