Friday, December 13, 2013

ora 4030 out of process memory when trying to allocate bytes ( pga heap,control file i/o buffer)

http://www.pythian.com/blog/yury-remember-this-is-how-you-disable-auto_tasks-in-11g/
How to Resolve ORA-4030 Errors on UNIX (Doc ID 199746.1)
Just checking whether above suggestions will work or not.
We are on 11g RAC on Linux machines with 38GB of RAM.
SGA_TARGET 12G and SGA_MAX_SIZE 20GB, PGA - 6GB

No comments:

Post a Comment