nc6.33数据库服务器参数配置说明

NC6.33SQLServerdb2setDB2_SKIPINSERTED=YESdb2setdb2setDB2_SKIPINSERTED=YESdb2setDB2_INLIST_TO_NLJN=YESdb2setdb2setupdatedbmcfgusingaslheapsz256;updatedbmcfgusingsheapthres20000 程序的最大数目(maxagents)updatedbmcfgusingmaxagents100;-- updatedbmcfgusingNUM_POOLAGENTS--1.--1.updatedatabaseconfigurationforncdata00usingDBHEAP4096updatedatabaseconfigurationforncdata00usinglogbufsz512updatedatabaseconfigurationforncdata00usingCATALOGCACHE_SZ1024updatedatabaseconfigurationforncdata00usinglocklist4096--updatedatabaseconfigurationforncdata00usingapp_ctl_heap_sz2048;updatedatabaseconfigurationforncdata00usingappl_memoryautomatic;--6.updatedatabaseconfigurationforncdata00usingsortheap2048updatedatabaseconfigurationforncdata00usingstmtheap2048updateupdatedatabaseconfigurationforncdata00usingapplheapsz1024updatedatabaseconfigurationforncdata00usingpckcachesz10240updatedatabaseconfigurationforncdata00usingmaxlocks--11.updatedatabaseconfigurationforncdata00usingNUM_IOCLEANERS1--12I/Oupdatedatabaseconfigurationforncdata00usingNUM_IOSERVERS1--13.updatedatabaseconfigurationforncdata00usingMAXAPPLS--14.updatedatabaseconfigurationforncdata00usingAVG_APPLSupdatedatabaseconfigurationforncdata00usinglogfilsiz updatedatabaseconfigurationforncdata00usinglogprimaryupdatedatabaseconfigurationforncdata00usinglogsecondupdatedatabaseconfigurationforncdata00MITupdateupdatedbmcfgusingaslheapszupdatedbmcfgusingsheapthres30000 程序的最大数目(maxagents)updatedbmcfgusingmaxagents150;-- updatedbmcfgusingNUM_POOLAGENTS--1.--1.updatedatabaseconfigurationforncdata00usingDBHEAP7168updatedatabaseconfigurationforncdata00usinglogbufsz1024updatedatabaseconfigurationforncdata00usingCATALOGCACHE_SZ2048updatedatabaseconfigurationforncdata00usinglocklist8192--updatedatabaseconfigurationforncdata00usingapp_ctl_heap_sz3072;updatedatabaseconfigurationforncdata00usingappl_memoryautomatic;--6.updatedatabaseconfigurationforncdata00usingsortheap3072updatedatabaseconfigurationforncdata00usingstmtheap3072updatedatabaseconfigurationforncdata00usingapplheapsz1024updatedatabaseconfigurationforncdata00usingpckcachesz15360updatedatabaseconfigurationforncdata00usingmaxlocks--13updatedatabaseconfigurationforncdata00usingNUM_IOCLEANERS1--14I/Oupdatedatabaseconfigurationforncdata00usingNUM_IOSERVERS1--15.updatedatabaseconfigurationforncdata00usingMAXAPPLS--16.updatedatabaseconfigurationforncdata00usingAVG_APPLSupdatedatabaseconfigurationforncdata00usinglogfilsiz updatedatabaseconfigurationforncdata00usinglogprimaryupdatedatabaseconfigurationforncdata00usinglogsecondupdatedatabaseconfigurationforncdata00MITupdatedbmcfgusingaslheapsz1024;updatedbmcfgusingsheapthres40000 程序的最大数目(maxagents)updatedbmcfgusingmaxagents300;-- updatedbmcfgusingNUM_POOLAGENTS--1.--1.updatedatabaseconfigurationforncdata00usingDBHEAP10240updatedatabaseconfigurationforncdata00usinglogbufsz2048updatedatabaseconfigurationforncdata00usingCATALOGCACHE_SZ3072updatedatabaseconfigurationforncdata00usinglocklist10240--updatedatabaseconfigurationforncdata00usingapp_ctl_heap_sz4096;updatedatabaseconfigurationforncdata00usingappl_memoryautomatic;--6.updatedatabaseconfigurationforncdata00usingsortheap4096updatedatabaseconfigurationforncdata00usingstmtheap3072updatedatabaseconfigurationforncdata00usingapplheapsz2048updatedatabaseconfigurationforncdata00usingpckcachesz20480--12updatedatabaseconfigurationforncdata00usingmaxlocks--13.updatedatabaseconfigurationforncdata00usingNUM_IOCLEANERS1--14--14I/Oupdatedatabaseconfigurationforncdata00usingNUM_IOSERVERS1--15.updatedatabaseconfigurationforncdata00usingMAXAPPLS--16.updatedatabaseconfigurationforncdata00usingAVG_APPLSupdatedatabaseconfigurationforncdata00usinglogfilsiz updatedatabaseconfigurationforncdata00usinglogprimaryupdatedatabaseconfigurationforncdata00usinglogsecondupdatedatabaseconfigurationforncdata00MITaltersystemset"_b_tree_bitmap_ sqlsqltuninglient_name=>'sqltuningadvisor', =>NULL,window_name=>NULL);/ altersystemsetevent='10949tracenamecontextforever,level1'scope=both;altersystemsetaudit_trail=nonescope=both; =0memory_target=0memory_max_target=1324Mdb_cache_size =0memory_target=0memory_max_target=1324Mdb_cache_size= shared_pool_size java_pool_size=log_buffer=open_cursors=2000 =autooptimizer_index_cost_adj=40 =0memory_target=0memory_max_target=1374Mdb_cache_size =0memory_target=0memory_max_target=1374Mdb_cache_size= shared_pool_size java_pool_size=log_buffer=db_write_processes=3open_cursors=2000 =autooptimizer_index_cost_adj=40sga_max_size =sga_max_size =memory_target=0memory_max_target=db_cache_size shared_pool_size large_pool_size=614400java_pool_size=log_buffer=open_cursors= =optimizer_index_cost_adj=40sga_max_size =sga_max_size =memory_target=0memory_max_target=db_cache_size shared_pool_size large_pool_size=614400java_pool_size=log_buffer=db_writer_processes=5open_cursors=2000 =autopga_aggregate_target= lock_sga=true(unix下参数，不包含solaris)optimizer_index_cost_adj=40sga_max_size=10737418240 =0memory_target=0memory_max_target=sga_max_size=10737418240 =0memory_target=0memory_max_target=db_cache_size shared_pool_size large_pool_size=614400java_pool_size=processesprocesses500（根据具体情况调大此值)log_buffer=db_writer_processes=open_cursors=2000 pga_agg