RE: Hugepages - benefits / drawbacks

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[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 Huang       

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l