para_ora（para_ora）.docVIP

para_ora（para_ora） ORACLE parameter configuration instructions NC runs in different application environments and needs to configure different ORACLE parameters. Here is the recommended parameter configuration table, Specific and then adjusted according to specific applications. Catalog Dear sirsre This hardware configuration in 2CPU, 2G memory, 32 bit database application This hardware configuration in 4CPU, 4G memory, 32 bit database application This hardware configuration in 4CPU, 4G memory, 64 bit database application This hardware configuration in 8CPU, 8G memory, 64 bit database application * hardware environment CPU 2 Memory 2048M Oracle 8i Version (32bit) About the number of concurrent users: around 30 Db_block_buffers = 76800 (600M) Shared_pool_size = 209715200 (200M) Large_pool_size = 614400 Java_pool_size =Processes = 80 Log_buffer = 5242880 Db_block_size = 8192 Sort_area_size = 5242880 Optimizer_index_cost_adj =40 Db_writer_processes =2 Open_cursors = 2000 Pre_page_sga = true (under WIN2000 parameter) Lock_sga = true (under UNIX, without Solaris) Oracle 9i Version (32bit) About the number of concurrent users: around 30 Db_cache_size = 629145600 (600M) Shared_pool_size = 209715200 (200M) Large_pool_size = 614400 Java_pool_size =Processes = 80 Log_buffer = 5242880 Db_block_size = 8192 Db_writer_processes =2 Open_cursors = 2000 Workarea_size_policy = Auto Pga_aggregate_target = 250M Pre_page_sga = true (under WIN2000 parameter) Lock_sga = true (under UNIX, without Solaris) Optimizer_index_cost_adj =40 Optimizer_dynamic_sampling=2 Oracle 10g Version (32bit) About the number of concurrent users: around 30 Db_cache_size = 629145600 (600M) Shared_pool_size = 209715200 (200M) Large_pool_size = 614400 Java_pool_size =Processes = 80 Log_buffer = 5242880 Db_block_size = 8192 Db_writer_processes =2 Open_cursors = 2000 Workarea_size_policy = Auto Pga_aggregate_target = 250M Optimizer_index_cost_adj =40 Pre_page_sga = true (under WIN2000 p