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:


  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.