Home » RDBMS Server » Server Administration » performance problems with oracle 8.1.6.
performance problems with oracle 8.1.6. [message #61998] Wed, 16 June 2004 22:43
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

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.

Report message to a moderator

Previous Topic: user banaged back ups
Next Topic: Advantages of 9i over 8i or Differences 8i and 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 05:10:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.