RE: Hugepages - benefits / drawbacks
Date: Tue, 7 Oct 2008 20:49:12 -0500
Be ware it's a 'hidden' parameter and thus it should not be implemented in production environments unless specifically suggested by Oracle or application vendor (SAP comes to mind). That being said, I do have access to Oracle on Solaris and will certainly try this parameter under load (hammerora) and report back ^_^
Perhaps if someone else does this test we can compare results as I will be running it on a virtual machine.
Guillermo Alan Bort
EDS - ITO DBA Main Group
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yong Huang Sent: Tuesday, October 07, 2008 3:56 PM
To: Christo Kutrovsky
Cc: oracle-l_at_freelists.org; krishmanoh_at_gmail.com Subject: Re: Hugepages - benefits / drawbacks
> On Tue, Oct 7, 2008 at 1:26 PM, Yong Huang
> <yong321_at_yahoo.com> wrote:
> > Hi Krishna,
> >> on Solaris PGA uses ISM
> > Wouldn't that cause PGA to be shared?
Tanel Poder's presentation "Memory Management and Latching Improvements in Oracle9i and 10g" mentions the parameter _use_ism_for_pga. It didn't register in my mind when I read it some time ago. I don't have access to Oracle on Solaris right now. Why does Oracle do this? It would be interesting to see the effect.
Yong HuangReceived on Tue Oct 07 2008 - 20:49:12 CDT