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
Independent Oracle performance consultant and researcher
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals
Henry Poras <henry.poras@xxxxxxxxx> hat am 16. März 2017 um 22:11 geschrieben:--
Hugepages are configured
Hugepagesize: 2048 kB
but isn't this just SGA? My problems are with PGA.
On Thu, Mar 16, 2017 at 4:08 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx
mailto:andrew.kerber@xxxxxxxxx > wrote:
> > Are your huge pages configured?
Sent from my iPad