Installation guide

33
Appendix 2: Oracle parameter settings
The following Oracle parameters were used for these tests:
 compatible = 11.2.0.0.1
 _enable_NUMA_support = TRUE
 _parallel_statement_queuing = TRUE
 _pga_max_size = 4294967296
 control_files = (+DATA//control_001, +DATA//control_002)
 db_32k_cache_size = 590558003200
 db_block_size = 8192
 db_cache_size = 64424509440
 db_file_multiblock_read_count = 512
 db_keep_cache_size = 32212254720
 db_name = BI
 dispatchers = (PROTOCOL=TCP) (SERVICE=BIXDB)
 dml_locks = 13516
 java_pool_size = 3758096384
 large_pool_size = 3758096384
 lock_sga = TRUE
 open_cursors = 300
 log_buffer = 10048576
 parallel_adaptive_multi_user = FALSE
 parallel_automatic_tuning = FALSE
 parallel_degree_policy = auto
 parallel_execution_message_size = 32768
 parallel_force_local = FALSE
 parallel_io_cap_enabled = FALSE
 parallel_max_servers = 640
 parallel_min_percent = 0
 parallel_min_servers = 320
 parallel_servers_target = 480
 parallel_threads_per_cpu = 2
 pga_aggregate_target = 214748364800
 plsql_optimize_level=2
 processes = 2000
 recovery_parallelism = 0
 result_cache_max_result = 2
 result_cache_max_size = 5368709120
 result_cache_mode = manual
 sga_max_size = 740881858560
 shared_pool_size = 21474836480
 sessions = 3072
 statistics_level = typical
 timed_statistics = true