修改aix操作系统参数maxclient%和maxperm%的一点记录

关于aix操作系统的参数maxclient%和maxperm%，有很多帖子有论述。包括白鳝的 《oracle优化日记--一个金牌DBA的故事》中也有论述，大概在书中的165到166页。具体我也记不清了。 该参数主要是了aix filesysemcache 使用（或者说直接占用）os 物理内存的比

关于aix操作系统的参数maxclient%和maxperm%，有很多帖子有论述。包括白鳝的 《oracle优化日记--一个金牌DBA的故事》中也有论述，大概在书中的165到166页。具体我也记不清了。

该参数主要是了aix filesysemcache 使用（或者说直接占用）os 物理内存的比例。

# vmo -a -F 
 ame_cpus_per_pool = 8
 ame_maxfree_mem = 0
 ame_min_ucpool_size = 0
 ame_minfree_mem = 0
 ams_loan_policy = n/a
 force_relalias_lite = 0
 kernel_heap_psize = 4096
 lgpg_regions = 0
 lgpg_size = 0
 low_ps_handling = 1
 maxfree = 1088
 maxperm = 1494126
 maxpin = 1402196
 maxpin% = 80
 memory_frames = 1736704
 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
 minfree = 960
 minperm = 49803
 minperm% = 3
 nokilluid = 0
 npskill = 16384
 npswarn = 65536
 numpsblks = 2097152
 pinnable_frames = 1291242
 relalias_percentage = 0
 scrub = 0
 v_pinshm = 0
 vmm_default_pspa = -1
 wlm_memlimit_nonpg = 1
##受限可调参数
 ame_sys_memview = 0
 cpu_scale_memp = 8
 data_stagger_interval = 161
 defps = 1
 framesets = 2
 htabscale = n/a
 kernel_psize = 4096
 large_page_heap_size = 0
 lru_file_repage = 0
 lru_poll_interval = 10
 lrubucket = 131072
 maxclient% = 90 <-------注意此行
 maxperm% = 90 <-------注意此行
 mbuf_heap_psize = 4096
 memory_affinity = 1
 npsrpgmax = 131072
 npsrpgmin = 98304
 npsscrubmax = 131072
 npsscrubmin = 98304
 num_spec_dataseg = 0
 page_steal_method = 1
 psm_timeout_interval = 5000
 rpgclean = 0
 rpgcontrol = 2
 scrubclean = 0
 soft_min_lgpgs_vmpool = 0
 spec_dataseg_int = 512
 strict_maxclient = 1
 strict_maxperm = 0
 vm_modlist_threshold = -1
 vmm_fork_policy = 1
 vmm_mpsize_support = 2
 vmm_vmap_policy = 0
# vmo -p -o maxclient%=20
修改受限可调参数 maxclient%，需要确认 y/n y
正在 nextboot 文件中将 maxclient% 设置为 20
正在将 maxclient% 设置为 20
警告：已更改受限可调参数 
# nmon
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x ------------------------------ 
x N N M M OOOO N N For online help type: h 
x NN N MM MM O O NN N For command line option help: 
x N N N M MM M O O N N N quick-hint nmon -? 
x N N N M M O O N N N full-details nmon -h 
x N NN M M O O N NN To start nmon the same way every time? 
x N N M M OOOO N N set NMON ksh variable, for example: 
x ------------------------------ export NMON=cmt 
x TOPAS_NMON 
x 8 - CPUs currently 
x 8 - CPUs configured 
x 1504 - MHz CPU clock rate 
x PowerPC_POWER5 - Processor 
x  bit - Hardware 
x  bit - Kernel 
x 1,65-7858E - Logical Partition 
x 6.1.4.1 TL04 - AIX Kernel Version 
x oradb1 - Hostname 
x oradb1 - Node/WPAR Name 
x 657858E - Serial Number 
x IBM,9117-570 - Machine Type 
 
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
lqtopas_nmonqqh=HelpqqqqqqqqqqqqqHost=oradb1qqqqqqqqqRefresh=2 secsqqq14:50.26qqqqqqqqqqqqqqqqqqqqqqqqqq
x Memory qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x Physical PageSpace | pages/sec In Out | FileSystemCache 
x% Used 79.4% 10.3% | to Paging Space 0.0 0.0 | (numperm) 19.0% <-------注意此行 
x% Free 20.6% .7% | to File System 30550.3 10.4| Process 34.7% 
xMB Used 5384.6MB 840.5MB | Page Scans 148325.4 | System 25.7% 
xMB Free 1399.4MB 7351.5MB | Page Cycles 0.0 | Free 20.6% 
xTotal(MB) 6784.0MB 8192.0MB | Page Steals 30414.7 | ------ 
x | Page Faults 1106.8 | Total 100.0% 
x------------------------------------------------------------ | numclient 19.0% 
xMin/Maxperm 195MB( 3%) 5836MB( 86%) <--% of RAM | maxclient 19.1% 
xMin/Maxfree 960 1088 Total Virtual 14.6GB | User 50.0% 
xMin/Maxpgahead 2 8 Accessed Virtual 4.4GB 30.1%| Pinned 25.7% 
xqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

注意上面倒数第三行中的： 5836MB( 86%) <--% of RAM <-------注意此行


# vmo -p -o maxperm%=20 <-------注意此行
修改受限可调参数 maxperm%，需要确认 y/n y
正在 nextboot 文件中将 maxperm% 设置为 20
正在将 maxperm% 设置为 20
警告：已更改受限可调参数
# nmon
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x ------------------------------ 
x N N M M OOOO N N For online help type: h 
x NN N MM MM O O NN N For command line option help: 
x N N N M MM M O O N N N quick-hint nmon -? 
x N N N M M O O N N N full-details nmon -h 
x N NN M M O O N NN To start nmon the same way every time? 
x N N M M OOOO N N set NMON ksh variable, for example: 
x ------------------------------ export NMON=cmt 
x TOPAS_NMON 
x 8 - CPUs currently 
x 8 - CPUs configured 
x 1504 - MHz CPU clock rate 
x PowerPC_POWER5 - Processor 
x  bit - Hardware 
x  bit - Kernel 
x 1,65-7858E - Logical Partition 
x 6.1.4.1 TL04 - AIX Kernel Version 
x oradb1 - Hostname 
x oradb1 - Node/WPAR Name 
x 657858E - Serial Number 
x IBM,9117-570 - Machine Type 
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
lqtopas_nmonqqh=HelpqqqqqqqqqqqqqHost=oradb1qqqqqqqqqRefresh=2 secsqqq14:51.33qqqqqqqqqqqqqqqqqqqqqqqqqq
x Memory qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x Physical PageSpace | pages/sec In Out | FileSystemCache 
x% Used 79.4% 10.3% | to Paging Space 0.0 0.0 | (numperm) 19.0% 
x% Free 20.6% .7% | to File System 65.4 10.5 | Process 34.7% 
xMB Used 5385.3MB 840.6MB | Page Scans 0.0 | System 25.7% 
xMB Free 1398.7MB 7351.4MB | Page Cycles 0.0 | Free 20.6% 
xTotal(MB) 6784.0MB 8192.0MB | Page Steals 0.0 | ------ 
x | Page Faults 652.1 | Total 100.0% 
x------------------------------------------------------------ | numclient 19.0% 
xMin/Maxperm 195MB( 3%) 1297MB( 19%) <--% of RAM | maxclient 19.1% 
xMin/Maxfree 960 1088 Total Virtual 14.6GB | User 50.0% 
xMin/Maxpgahead 2 8 Accessed Virtual 4.4GB 30.1%| Pinned 25.7% 
xqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

注意上面倒数第三行中的：1297MB( 19%) <--% of RAM <-------注意此行