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>
Are your huge pages configured?
Sent from my iPad
On Mar 16, 2017, at 2:02 PM, Stefan Koehler <contact@xxxxxxxx> wrote:https://www.kernel.org/doc/Documentation/x86/x86_64/mm.txt) limit of 128
Could there be another place that Linux is limiting the process?
Linux x86_64 has a theoretically VAS (virtual address space -
management / allocator ( mmap() and munmap() ) was introduced with Oracle
Has the Oracle PGA allocation changed in 12c?
Yes and no (depends on what you compare it with). Realfree memory
there was a limit of 16 GB when using it. However this limit was raisedto 80 GB by bug fix #14119856 but personally i have never tested it as my
does not have 80 GB of RAM - i am just a poor independent guy, you know;-)
system set "_use_realfree_heap"=FALSE;) and check if you can use more heap
Just try to disable realfree memory management / allocator (SQL> alter
Independent Oracle performance consultant and researcher
Upcoming online seminar: http://tinyurl.com/17-06-13-
Henry Poras <henry.poras@xxxxxxxxx> hat am 16. März 2017 um 18:19
aggregate function which is instantiating lots of (untunable) pga memory.
I am running on Oracle 22.214.171.124
We are currently getting 4030 (timobj call) which I have tracked to an
is erroring out at 32GB. I am trying to see if this is an Oracle limit (in
Our pga_aggregate_target is 700GB and
our pga_aggregate_limit is 900G
We are not coming close to using our aggregate memory, yet the process
rise) or a linux one.the past versions, this kind of untunable allocation would continue to
Could there be another place that Linux is limiting the process? Has the
I have checked both ulimit -a and ulimit -Hm with both being unlimited.
Oracle PGA allocation changed in 12c?