修改aix作業系統參數maxclient%和maxperm%的一點記錄

關于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
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%     89.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
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%     89.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  <-------注意此行