UNIX for Advanced & Expert Users

1) add the following entries to the /etc/system file (to enable larger cluster sizes then 128k)
*
* Allow larger SCSI I/O transfers, parameter is bytes (i can prolly scale this down to 512)
*
set maxphys = 1048576

*
* Allow larger DiskSuite I/O transfers, parameter is bytes (i can prolly scale this down to 512)
*
set md_maxphys = 1048576

2) set new cluster size to 512 for the FS (/dev/md/dsk/d100)
#RAID level 0, striping - Cluster size = number of stripe members x interlace size
tunefs -a 64 /dev/md/dsk/d100

3) set the ufs write throttle
*
* ufs_LW = 1/128th of memory
* ufs_HW = 1/64th of memory
*
set ufs_LW=16777216
set ufs_HW=33554432

4) disable fs caching edit /etc/vfstab and add option
nologging,forcedirectio

db_name = DEFAULT

db_file_multiblock_read_count = 8                                     # SMALL

db_block_buffers = 60                                                 # SMALL

shared_pool_size = 3500000                                            # SMALL

log_checkpoint_interval = 10000

processes = 50                                                        # SMALL

dml_locks = 100                                                       # SMALL

log_buffer = 8192                                                     # SMALL

sequence_cache_entries = 10                                           # SMALL

sequence_cache_hash_buckets = 10                                      # SMALL

max_dump_file_size = 10240      # limit trace file size to 5 Meg each

# 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

# FOR DEVELOPMENT ONLY, DEFAULT TO SINGLE-PROCESS
# single_process = TRUE

# FOR DEVELOPMENT ONLY, ALWAYS TRY TO USE SYSTEM BACKING STORE
# vms_sga_use_gblpagfil = TRUE

# FOR BETA RELEASE ONLY.  Enable debugging modes.  Note that these can
# adversely affect performance.  On some non-VMS ports the db_block_cache_*
# debugging modes have a severe effect on performance.

_db_block_cache_protect = true                       # memory protect buffers
event = "10210 trace name context forever, level 2" # data block checking
event = "10211 trace name context forever, level 2" # index block checking
event = "10235 trace name context forever, level 1" # memory heap checking
event = "10049 trace name context forever, level 2" # memory protect cursors

# define two control files by default
control_files = (ora_control1, ora_control2)