RE: Problems with large pages on AIX after upgrading to 10.2.0.4.3

No, we didn’t see any AIX errors, but it was weird what would happen when we started up the instance before we tried setting ORACLE_SGA_PGSZ. We’d set lgpg_regions=64 and reboot the host, then when it came up, it would show the 64 pages allocated in the output of svmon –G and vmstat –l, like this:

large-page

alp flp
0 64

But after we’d start the Oracle instance, the value of flp would go down by some odd number, but alp wouldn’t go up like it should:

large-page

alp flp
0 35

After setting ORACLE_SGA_PGSZ=16m and increasing lgpg_regions=65, we now see all the pages allocated to Oracle as expected:

large-page

alp flp
65 0

Regards,
Brandon

From: patrick obrien [mailto:po04541_at_yahoo.com]

Allen,
did you get any kind of aix error? errpt -a, if so, ibm might have a fix for this.
POB.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.