RE: [Sydney-Oracle] memory large pages for oracle on AIX
| From: | Nuno Pinto do Souto |
| Sent on: | Wednesday, December 21, 2011 9:06 AM |
And in 7.1 it all changes once again…. Currently going through the “diffs” document and still haven’t found the “sweet spot”.
I wish they’d stop messing around with the largepage and shm settings and just leave them alone - and simple!
Same goes for Oracle. It adds to the disruption of new releases when things are not made clear enough in the doco.
Nuno Pinto Do Souto
Snr Bus Sys Infrast Specialist
From: [address removed] [mailto:[address removed]]
On Behalf Of Taral
Sent: Wednesday, 21 December 2011 6:13 AM
To: [address removed]
Subject: Re: [Sydney-Oracle] memory large pages for oracle on AIX
Well In Aix 6 onwards it's not required to edit oracle binary
When you set LDR_CNTRL parameter then it take precedence of any other settings
Also Updating XCOFF through ldedit not support setting of SHMPSIZE
On Mon, Dec 19, 2011 at 7:22 PM, Andrey Goryunov <[address removed]> wrote:
Thank you!
On 20 December 2011 12:09, Nuno Pinto do Souto <[address removed]> wrote:
Oh, and make sure you define the caps and the vmo stuff BEFORE you setup the env variables or nothing will work!
sent from Nuno's iPhone
DBA team
On 20/12/2011, at 12:04 PM, "Nuno Pinto do Souto" <[address removed]> wrote:
No need to recompile. 11g already has the bits set on default install.
As for the environment variables, they are needed until Aix 7.1. The vmo stuff changed with 7.1, still figuring it out...
sent from Nuno's iPhoneDBA team
On 20/12/2011, at 11:55 AM, "Andrey Goryunov" <[address removed]> wrote:Thank you very much Nuno!
do I still need to recompile oracle 11.2
after settings ldedit -b lpdata oracle
to use large pages
and is export LDR_CNTRL=LARGE_PAGE_TEXT=Y@LARGE_PAGE_DATA=M required
for 11.2? Isn't oracle smart enough already (with LOCK_SGA=TRUE) to use large pages
if they configured w/o LDR_CNTRL?
Regards,
AndreyOn 20 December 2011 11:36, Nuno Pinto do Souto <[address removed]> wrote:
Yup, very much that?s it. You only missed the setting of the environment variables for user Oracle.
I set mine in the .profile, which means that everything under user Oracle uses largepages: SGA, sqlplus, lsnrctl, ls, rm, man, you name it! J
I?ve got a page with all the gory details for Aix 5.3 and 10.2.0.3 here:
http://dbasrus.blogspot.com/2009/06/size-sometimes-does-matter.html
Tested it with 11.2.0.3 and 6.1 and it all works.
Currently doing 7.1 tests: that one is mighty different, though?
Nuno Pinto Do Souto
Snr Bus Sys Infrast Specialist
Westfield Information Technology
T
M
W
E
From: [address removed] [mailto:[address removed]] On Behalf Of Andrey Goryunov
Sent: Tuesday, 20 December 2011 11:29 AM
To: [address removed]
Subject: [Sydney-Oracle] memory large pages for oracle on AIX
Hello all,
just wondering what techniquies do you use to set usage of memory large
pages for oracle on AIX
Do you rely on LOCK_SGA=TRUE only or changed memory parameters
in addition.
Let's say if I have oracle 11.2.0.2 on AIX 6.1 (32Gb) with memory_target of 20Gb
how would you configure it?
To use large pages for SGA I would perform the following:
1. chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle
2. vmo -p -o lgpg_regions=<num_of_large_pages> -o lgpg_size=16777216
where num_of_large_pages = INT((total_SGA_size-1)/16MB)+1
(will put memory_target)
3. set v_pinshm to 1
4. set LOCK_SGA=TRUE and bounce db
Would it be enough?
--
Sincerely,
Andrey Goryunov.
______________________________________________________
CONFIDENTIALITY NOTICE
This electronic mail message, including any and/or all attachments, is for the sole use of the intended recipient(s), and may contain confidential and/or privileged information, pertaining to business conducted under the direction and supervision of the sending organization. All electronic mail messages, which may have been established as expressed views and/or opinions (stated either within the electronic mail message or any of its attachments), are left to the sole responsibility of that of the sender, and are not necessarily attributed to the sending organization. Unauthorized interception, review, use, disclosure or distribution of any such information contained within this electronic mail message and/or its attachment(s), is (are) strictly prohibited. If you are not the intended recipient, please contact the sender by replying to this electronic mail message, along with the destruction all copies of the original electronic mail message (along with any attachments).
______________________________________________________
Offer a perk for our members and get exposure.
Offer a perk →
People in thisMeetup are also in:
-
-
-
-
-
262 Data masters
-
