#25
對init.ora文件中的參數:db_block_buffers,shared_pool_size,db_block_size這幾個參數影響最大,其中db_block_size只有在建庫時指定,不能修改,默認為2k,最好改成8k以上。具體配置要根據你的服務器的硬件配置來設置,可以給一個大概的配置如下:
如果服務器內存為512 M,連接100台客戶機則:
增加以下參數:
open_cursors = 400
dml_locks = 500
transactions = 200
修改以下參數為下列值:
db_block_buffers = 50000
shared_pool_size = 150000000
processes = 120
log_buffer = 32768
global_names = false
job_queue_processes = 6
如果服務器內存為256 m,連接50台客戶機則:
增加以下參數:
open_cursors = 400
dml_locks = 500
transactions = 150
修改以下參數為下列值:
db_block_buffers = 25000
shared_pool_size = 75000000
processes = 80
log_buffer = 32768
global_names = false
job_queue_processes = 6
如果服務器內存為128m,連接20台客戶機則:
增加以下參數:
open_cursors = 400
dml_locks = 500
transactions = 100
修改以下參數為下列值:
db_block_buffers = 15000
shared_pool_size = 40000000
processes = 50
log_buffer = 32768
global_names = false
job_queue_processes = 6