Re: M000 process larger PGA size in Linux X64 than Windows X64

Hey Jeffrey,
huge pages have nothing to do with PGA (= private heap memory) and transparent huge pages should be disabled for Oracle anyway.

For the beginning just follow my document (starting on page 16) for troubleshooting the PGA usage: http://www.soocs.de/public/talk/161115_DOAG2016_Hacking_Oracles_Memory_About_Internals_Troubleshooting_PDF.pdf

There are cases when v$process_memory_detail does not show anything (useful) and you have to use Intel's PinTools for deeper investigations but let's don't go this way first.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> hat am 26. Oktober 2018 um 21:38 geschrieben:
>
> Running Oracle 11.2.0.4. Doing a migration from Windows to Linux. We are noticing considerably larger pga size for the m000 process. Anyone know of a memory leak or is this expected from changing platforms. We are using Hugepages in Linux and not in Windows. In Windows the PGA for M000 is around 30M and on our Linux instance about 170 M - a considerable difference.
>
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113

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