AIX 6.1, ORACLE 11G LOCK_SGA, LAGE_PAGE_SIZE(16MB) IMPORTANT!!!

網上找了一大堆垃圾文章，沒有一個人負責任地將關鍵的地方講出來，害得我鬱悶了三天，還把其中一個系統給搞垮了，徹底啟動不了了，還得IBM工程師重灌系統。。。

媽的，哪想到有時候學到芝麻一點的IT技術竟然如此多的障礙，高手在哪裡？？ 都隱居了，改行了，退出江湖了？？？

現在公司根本招不到像樣的人才，都是一群SB在幹活，寫的程式碼錯誤百出，而且竟都是低階錯誤，一點常識都沒有，害得架構師們天天陪著加班到凌晨，甚至3點都還在加班。

這是什麼世道。。。。。

好了，言歸正傳，本人經歷過血的代價後，現在將這微不足道的技能貢獻出來，希望後來人少走彎路：

---------Topic : use lock_sga=true in AIX +ORACLE PLATFORM.

aix setttings :

lgpg_regions = 3200 (50G) , Attention: this value must be larger than sga_max_size parameter of oracle , because os process will use it ,and oracle program will use sga_max_size+16MB .
lgpg_size = 16777216 (16m)

v_pinshm = 1

sometimes, if the value lgpg_regions could not satified SGA_MAX_SIZE, the os parameter lgpg_regions will reset to a default value . So you must be careful to check it when system is lower response.

---- check if the value is effective.

# svmon -G
size inuse free pin virtual mmode
memory 16351232 14509377 1841855 14047691 14389748 Ded
pg space 10616832 90794

work pers clnt other
pin 13449211 0 0 471504
in use 14312157 0 70244

PageSize PoolSize inuse pgsp pin virtual
s 4 KB - 753777 90794 613547 761124
m 64 KB - 40525 0 20434 40525
L 16 MB 3200 3169 0 3200 3169
---- just as above , 3169 is current used 16M page frames .

sample :

get the pid of ora_dbw0_HLTRADE , such as 12911022,then issue:

svmon -P 12911022

--------output result :

# svmon -P 12911022

-------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB
12911022 oracle 12683550 12595264 3508 12624382 Y N Y

PageSize Inuse Pin Pgsp Virtual
s 4 KB 64510 0 3508 5342
m 64 KB 2002 516 0 2002
L 16 MB 3073 3073 0 3073

Vsid Esid Type Description PSize Inuse Pin Pgsp Virtual
fc0e7c 70000025 work default shmat/mmap L 16 16 0 16
972f97 70000071 work default shmat/mmap L 16 16 0 16
fb117b 7000002f work default shmat/mmap L 16 16 0 16
902f90 7000009a work default shmat/mmap L 16 16 0 16
933113 70000008 work default shmat/mmap L 16 16 0 16
953215 70000066 work default shmat/mmap L 16 16 0 16
ee11ee 70000014 work default shmat/mmap L 16 16 0 16
e91069 70000097 work default shmat/mmap L 16 16 0 16
fe197e 7000005a work default shmat/mmap L 16 16 0 16
dd0cdd 70000003 work default shmat/mmap L 16 16 0 16
f818f8 70000082 work default shmat/mmap L 16 16 0

--- here , L (large page used) 16 (large page size ).

according the output. It means that the oracle process really use large page (16mb) .

Here we successfully realize LOCK_SGA and Large_pool settings.

[@more@]