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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/350519/viewspace-1049598/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/350519/viewspace-1049598/