Link to home
Start Free TrialLog in
Avatar of arak
arak

asked on

init.ora settings good or bad?

I use Oracle 8.0.5 on Solaris 2.6, with dual SPARC-cpu, 1 Gig of RAM and Raid 0,1 disk drives.

Our anvironment is mixed, OLTP and large Batches.

Are my locks, processes, MTS dispatchers, SGA settings configured correctly, or is there a recipe for disaster I don't see? I'm applying these settings this week, so a quick answer is APPRECIATED.

Unix level settings:
SHMMAX       4,294,967,296
SHMMIN      1
SHMMNI      100
SHMSEG      10
SEMMNS      300
SEMMNI      100
SEMMSL      200            

init.ora settings:
 
db_block_buffers            30,603
db_block_size                  8,196
db_file_multiblock_read_count      32
distributed_lock_timeout      60
distributed_transactions      0
dml_locks                        200
gc_latches                        4
gc_lck_procs                  1
hash_area_size                  67,108,864
hash_join_enabled            TRUE
hash_multiblock_io_count      8
large_pool_min_alloc            16M
large_pool_size                  32M
lock_sga                        TRUE
log_archive_buffers            4
log_archive_buffer_size      64
log_buffer                        2,163,840
mts_dispatchers                  (DIS=10)
                              (SES=254)
                              (CON=254)
mts_max_dispatcher            10
mts_max_servers                  20
mts_servers                  5
processes                        300
shared_pool_reserved_min_alloc      5k
shared_pool_reserved_size      6,000,000
shared_pool_size            60,000,000
sort_area_retained_size      500,000
sort_area_size                  50,000,000
sort_direct_writes            TRUE
sort_read_fac                  16
sort_write_buffers            4
sort_write_buffer_size      65,536
spin_count                        100
ASKER CERTIFIED SOLUTION
Avatar of mshaikh
mshaikh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of arak
arak

ASKER

Thanks!

It's so great to have an extra pair of eyes on my work.

This site is a lifesaver!!!!
You'r welcome! And thank you!