Re: ORA-04030 possible unix limits??

Hey Henry,
yes, you are right that huge pages are related to SGA.

However there is something called THP (transparent huge pages) but these can currently only map anonymous memory regions such as heap and stack space - so PGA related. THP should be disabled at all (MOS ID #1557478.1) and can be monitored by AnonHugePages in /proc/meminfo or in /proc/<PID>/smap.

After all - please forget the huge pages topic as your issue is not related to it ;-)  

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals  

> Henry Poras <henry.poras_at_gmail.com> hat am 16. März 2017 um 22:11 geschrieben:
>
> Hugepages are configured
>
> HugePages_Total: 384000
> HugePages_Free: 25663
> HugePages_Rsvd: 10
> HugePages_Surp: 0
> Hugepagesize: 2048 kB
>
>
> but isn't this just SGA? My problems are with PGA.
>
> Henry
>
> On Thu, Mar 16, 2017 at 4:08 PM, Andrew Kerber <andrew.kerber_at_gmail.com mailto:andrew.kerber_at_gmail.com > wrote:
> > > Are your huge pages configured?
> >
> > Sent from my iPad

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