Home » RDBMS Server » Performance Tuning » Oracle 8.1.6 performance on NT4
Oracle 8.1.6 performance on NT4 [message #65217] Thu, 17 June 2004 06:49
Anto
Messages: 6
Registered: October 2002
Junior Member
I installed oracle 8.1.6  on NT4 (Pentium II - 224 mb ram), with default database and then I imported two schemas from another db. Now i have some troubles: I see that the performance is very slow.

I think I must change settings of init.ora file  - I want write this on my init.ora file:

INITIAL # db_file_multiblock_read_count = 8  #                                 
 db_file_multiblock_read_count = 16       

INITIAL # db_block_buffers = 2048  #                                           
 db_block_buffers = 3200      

INITIAL # shared_pool_size =  15728640  # 

 shared_pool_size = 9000000                                        

# large_pool_size = 614400 # INITIAL
# java_pool_size = 20971520 # INITIAL  -- no java

large_pool_size = 1144000
java_pool_size = 1571520

log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800

# processes = 59  # INITIAL          
 processes = 100                                                    
                                                                        

# log_buffer = 32768  # INITIAL
 log_buffer = 163840

Could you suggest me if I have to do more ?

Thank you.
Previous Topic: db_cache_size
Next Topic: urgent.
Goto Forum:
  


Current Time: Wed Feb 21 19:44:42 CST 2024