Re: Q:Good preformance

Hi

[Quoted] For one you could increase the block size to 8192, 16384 etc. if your O/S allows you to. I see you have lots of rollback segments. It will help if [Quoted] you indicate how it was created and if there is contention. For inserts and updates you have to look at the parameters on the tables PCTUSED, PCTFREE as well as storage parameters for fragmentation.

You're init.ora parameter is not the only thing to look at when tuning for performance. You could use the utilities UTLBSTAT, UTLESTAT or ORACLE EXPERT in the Enterprise Manager Suite.

Please let me know if this was of any help to you.

Email me at akader_at_health.sanlam.co.za

Cheers

Marre <marre_at_mbox306.swipnet.se> wrote in article <01bcbf91$f7d7a800$f39ef482_at_MFO_PC.tmcom.se>...
> 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 19 1997 - 00:00:00 CEST