Marre wrote:
>
> 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
>
> ############################################################################
> ###
I would try increasing:
db_block_buffers,
log_checkpoint_interval Ex: 10000000000000.
Check your alert log for indications of RedoLog problems.
--
Ronny Ivarsen
ivarsen_at_online.no
--
Ronny Ivarsen
ivarsen_at_online.no
Received on Sat Sep 13 1997 - 00:00:00 CDT
