内核参数调整后,只做参考值...ORACLE 10GR2#vmo -a cpu_scale_memp = 8 data_stagger_interval = 161 defps = 1 force_relalias_lite...
显示全部
内核参数调整后,只做参考值...ORACLE 10GR2
#vmo -a
cpu_scale_memp = 8
data_stagger_interval = 161
defps = 1
force_relalias_lite = 0
framesets = 2
htabscale = n/a
kernel_heap_psize = 4096
kernel_psize = 16777216
large_page_heap_size = 0
lgpg_regions = 0
lgpg_size = 0
low_ps_handling = 1
lru_file_repage = 1
lru_poll_interval = 10
lrubucket = 131072
maxclient% = 10
maxfree = 1088
maxperm = 1562652
maxperm% = 10
maxpin = 13110919
maxpin% = 80
mbuf_heap_psize = 65536
memory_affinity = 1
memory_frames = 16252928
memplace_data = 2
memplace_mapped_file = 2
memplace_shm_anonymous = 2
memplace_shm_named = 2
memplace_stack = 2
memplace_text = 2
memplace_unmapped_file = 2
mempools = 4
minfree = 960
minperm = 781325
minperm% = 5
nokilluid = 0
npskill = 131072
npsrpgmax = 1048576
npsrpgmin = 786432
npsscrubmax = 1048576
npsscrubmin = 786432
npswarn = 524288
num_spec_dataseg = 0
numpsblks = 16777216
page_steal_method = 0
pagecoloring = n/a
pinnable_frames = 15344851
psm_timeout_interval = 5000
pta_balance_threshold = n/a
relalias_percentage = 0
rpgclean = 0
rpgcontrol = 2
scrub = 0
scrubclean = 0
soft_min_lgpgs_vmpool = 0
spec_dataseg_int = 512
strict_maxclient = 1
strict_maxperm = 1
v_pinshm = 0
vm_modlist_threshold = -1
vmm_fork_policy = 1
vmm_mpsize_support = 1
wlm_memlimit_nonpg = 1
(1)配置异步IO
#smit chgaio
如果使用文件系统,那么max number of requests至少应该是8192。
如果使用裸设备,这个参数可以小一些,不过还是建议加大。MIN和MAX SERVER的数量根据实际情况来设置,这个参数是每个CPU的数量。
这个设置需要重启服务器。
(2)配置一些基本的系统参数:
#smit chgsys
其中每个用户允许的最大进程数肯定要修改,修改为多大根据你的数据库的配置
Maximum number of PROCESSES allowed per user:2048
收起