恒生推荐Oracle参数配置

金融it

alter system set open_cursors=20000 scope=spfile sid='*';
alter system set session_cached_cursors=300 scope=spfile sid='*';
alter system set OPTIMIZER_INDEX_COST_ADJ=10 scope=spfile sid='*';
alter system set max_dump_file_size ="10G" scope=spfile sid='*';
alter system set deferred_segment_creation=false scope=spfile sid='*';
alter system set SEC_CASE_SENSITIVE_LOGON =FALSE scope=both sid='*';
alter system set parallel_force_local=true scope=spfile sid='*';
alter system set "_use_adaptive_log_file_sync"=false scope=spfile sid='*';
alter system set db_file_multiblock_read_count=16 scope=spfile sid='*';
alter system set optimizer_index_caching=90 scope=spfile sid='*';
alter system set event='28401 trace name context forever, level 1:10949 trace name context forever,level 1' scope=spfile sid='*';
alter system set dispatchers='' scope=spfile sid='*';
alter system set db_file_multiblock_read_count=16 scope=spfile sid='*';
alter system set db_writer_processes=4 scope=spfile sid='*'; (根据系统调整)
alter system set db_files=2048  scope=spfile sid='*'; (根据业务系统调整)
alter system set optimizer_mode=ALL_ROWS scope=spfile sid='*';(根据业务系统调整)
alter system set processes=3000 scope=spfile sid='*'; (根据业务系统调整)

alter system set sga_max_size=12G scope=spfile sid='*'; (根据系统调整)
alter system set sga_target=12G scope=spfile sid='*';
alter system set pga_aggregate_target=4G scope=spfile sid='*';

注：sga_max_size+ pga_aggregate_target=物理内存/2 （可适当放大）
sga_max_size=(物理内存/2) *(2/3)
pga_aggregate_target=(物理内存/2) *(1/3)
sga_target=sga_max_size
以上是物理内存32G示例

金融it

alter system set open_cursors=20000 scope=spfile sid='*';
alter system set session_cached_cursors=300 scope=spfile sid='*';
alter system set OPTIMIZER_INDEX_COST_ADJ=10 scope=spfile sid='*';
alter system set max_dump_file_size ="10G" scope=spfile sid='*';
alter system set deferred_segment_creation=false scope=spfile sid='*';
alter system set SEC_CASE_SENSITIVE_LOGON =FALSE scope=both sid='*';
alter system set parallel_force_local=true scope=spfile sid='*';
alter system set "_use_adaptive_log_file_sync"=false scope=spfile sid='*';
alter system set db_file_multiblock_read_count=16 scope=spfile sid='*';
alter system set optimizer_index_caching=90 scope=spfile sid='*';
alter system set event='28401 trace name context forever, level 1:10949 trace name context forever,level 1' scope=spfile sid='*';
alter system set dispatchers='' scope=spfile sid='*';
alter system set db_file_multiblock_read_count=16 scope=spfile sid='*';
alter system set db_writer_processes=4 scope=spfile sid='*'; (根据系统调整)
alter system set db_files=2048  scope=spfile sid='*'; (根据业务系统调整)
alter system set optimizer_mode=ALL_ROWS scope=spfile sid='*';(根据业务系统调整)
alter system set processes=3000 scope=spfile sid='*'; (根据业务系统调整)

alter system set sga_max_size=12G scope=spfile sid='*'; (根据系统调整)
alter system set sga_target=12G scope=spfile sid='*';
alter system set pga_aggregate_target=4G scope=spfile sid='*';

注：sga_max_size+ pga_aggregate_target=物理内存/2 （可适当放大）
sga_max_size=(物理内存/2) *(2/3)
pga_aggregate_target=(物理内存/2) *(1/3)
sga_target=sga_max_size
以上是物理内存32G示例