Customizing the initsid.ora File

Some initsid.ora parameter settings are generic to any size installation. For those parameter settings requiring different values for different size installations, three scenarios are provided: small, medium, and large. In the sample initsid.ora file, parameters dependent on installation size are shown for each setting. You can comment out settings that do not apply to your installation by inserting a pound sign (#) at the beginning of a line.

Table 1 - 3 suggests the approximate SGA sizes corresponding to the three scenarios provided for in the initsid.ora file.

Installation/Database Size
Block Size		Small	Medium	Large
2KB		4500K	6800K	17000K
4 KB		5500K	8800K	21000K

Table 1 - 3. Block and SGA Sizes for Sample initsid.ora File

See Also: "Default Database" for a description of the OFA-compliant database you can create with the Oracle Installer.

Sample initsid.ora File

db_name = DEFAULT

db_files = 20

db_file_multiblock_read_count = 8     # SMALL

#db_file_multiblock_read_count = 16   # MEDIUM

#db_file_multiblock_read_count = 32   # LARGE

db_block_buffers = 200                # SMALL

#db_block_buffers = 550               # MEDIUM

#db_block_buffers = 3200              # LARGE

shared_pool_size = 3500000            # SMALL

#shared_pool_size = 6000000           # MEDIUM

#shared_pool_size = 9000000           # LARGE

log_checkpoint_interval = 10000

processes = 50                        # SMALL

#processes = 100                      # MEDIUM

#processes = 200                      # LARGE

dml_locks = 100                       # SMALL

#dml_locks = 200                      # MEDIUM

#dml_locks = 500                      # LARGE

log_buffer = 8192                     # SMALL

#log_buffer = 32768                   # MEDIUM

#log_buffer = 163840                  # LARGE

sequence_cache_entries = 10           # SMALL

#sequence_cache_entries = 30          # MEDIUM

#sequence_cache_entries = 100         # LARGE

sequence_cache_hash_buckets = 10      # SMALL

#sequence_cache_hash_buckets = 23     # MEDIUM

#sequence_cache_hash_buckets = 89     # LARGE

#audit_trail = true                   # if you want auditing

#timed_statistics = true              # if you want timed

                                      # statistics

#max_dump_file_size = 10240           # limit trace file

                                      # size to 5MB each

# Uncommenting the line below will cause automatic archiving # if archiving was enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true       
# log_archive_dest = disk$rdbms:[oracle.archive] 
# log_archive_format = "T%TS%S.ARC" 
 
# If using private rollback segments, place lines of the
# following form in each of your instance-specific
# init.ora files:
# rollback_segments = (name1, name2)    
 
# If using public rollback segments, define how many 
# rollback segments each instance will pick up, 
# using the formula 
# number of rollback segments = 
#	transactions / transactions_per_rollback_segment 
# In this example each instance will grab 40/10 = 4: 
# transactions = 40  
# transactions_per_rollback_segment = 10  
 
# Global Naming -- enforce that a dblink has same name as
# the db it connects to 
global_names = TRUE 
 
# Edit and uncomment the following line to provide the
# suffix that will be 
# appended to the db_name parameter (separated with a dot)
# and stored as the 
# global database name when a database is created.
# If your site uses Internet Domain names for e-mail, 
# then the part of your e-mail address after 
# the '@' is a good candidate for this parameter value.
 
# db_domain = us.acme.com       
# global database name is db_name.db_domain