Q:Good preformance

From: Marre <marre_at_mbox306.swipnet.se>
Date: 1997/09/12
Message-ID: <01bcbf91$f7d7a800$f39ef482@MFO_PC.tmcom.se>#1/1

Hello
I've got the following INIT.ORA file, does anybody know who I can tune the INIT.ORA file for best preformance. I've got lots of inserts and updates in my applikation.

//Martin

############################################################################
###

db_name = NAME
db_files = 100
control_files = VOL4:idok\ctl1.ctl,

                VOL1:dbcopy\idok\ctl2.ctl

ROLLBACK_SEGMENTS=(RB1,RB2,RB3,rb4,rb5,rb6,rb7,rb8,rb9,rb10,rb11,rb12,rb13,r b14,rb15,rb16)

compatible = 7.3.2.0.0

db_file_multiblock_read_count = 8 # INITIAL
# db_file_multiblock_read_count = 8 #
SMALL
# db_file_multiblock_read_count = 16 #
MEDIUM
# db_file_multiblock_read_count = 32 #
LARGE

db_block_buffers =  7500                           # INITIAL


#db_block_buffers = 200                                               #

SMALL  


# db_block_buffers = 550                                              #

MEDIUM 


# db_block_buffers = 3200                                             #

LARGE
#shared_pool_size = 3500000 # INITIAL
# shared_pool_size = 3500000 #
SMALL
# shared_pool_size = 6000000 #
MEDIUM

shared_pool_size = 40000000                                          #

LARGE log_checkpoint_interval = 10000

open_cursors = 512

# processes = 50 # INITIAL
# processes = 50 #
SMALL
# processes = 100 #
MEDIUM

processes = 200                                                     # LARGE
 



# dml_locks =  100                                         # INITIAL

# dml_locks = 100                                                     #

SMALL  


# dml_locks = 200                                                     #

MEDIUM 


# dml_locks = 1000                                                     #

LARGE

log_buffer =  8192                                       # INITIAL


# log_buffer = 8192                                                   #

SMALL


# log_buffer = 32768                                                  #

MEDIUM


# log_buffer = 163840                                                 #

LARGE

sequence_cache_entries =  10               # INITIAL


# sequence_cache_entries = 10                                         #

SMALL  


# sequence_cache_entries = 30                                         #

MEDIUM 


# sequence_cache_entries = 100                                        #

LARGE

sequence_cache_hash_buckets =  10     # INITIAL


# 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 5 Meg each

# log_archive_start = true # if you want automatic archiving
# log_archive_format = arc%s.arc # Namnet på logfilerna
# log_archive_dest = vol1:archive\idok # Var filerna skall hamna

# define directories to store trace and alert files
background_dump_dest=vol4:idok\trace
user_dump_dest=vol4:idok\trace

db_block_size = 4096

remote_login_passwordfile = shared

os_authent_prefix = ""
# os_roles = true

# See release notes for the description of the event
event = " 10805 trace name context forever, level 1 "

# Lite parametrar

dml_locks                  = 1200
optimizer_mode             =  rule
job_queue_processes        = 3    # tree background processes
job_queue_interval         = 30   # the processes wake up every 30 seconds

job_queue_keep_connections = TRUE # sleep, don't disconnect

############################################################################
###
Received on Fri Sep 12 1997 - 00:00:00 CDT