Part III--Optimizing Instance Performance--Chapter 4--Configuring a Database for Performance

Part III  Optimizing Instance Performance

Chapter 4  Configuring a Database for Performance 

sections:

• Performance Considerations for Initial Instance Configuration
• Creating and Maintaining Tables for Good Performance
• Performance Considerations for Shared Servers

  Parameter	Description
  DB_NAME	Name of the database. This should match the ORACLE_SID environment variable.
  DB_DOMAIN	Location of the database in Internet dot notation.
  OPEN_CURSORS	Limit on the maximum number of cursors (active SQL statements) for each session. The setting is application-dependent; 500 is recommended.
  CONTROL_FILES	Set to contain at least two files on different disk drives to prevent failures from control file loss.
  DB_FILES	Set to the maximum number of files that can assigned to the database.