Thanks for the question, Md.Rahim.
Asked: January 11, 2020 - 11:33 am UTC
Last updated: January 13, 2020 - 4:10 am UTC
Version: 11.2
Viewed 1000+ times
You Asked
Dear Sir ,
Few Day i face Production Database Out of process memory Oracle Database Release 11.2.0.1.0
My Problem is :
ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
How can i solve this problem , Please Help
and Connor said...
There are various potential causes - some due to bugs, some due to genuine memory limits.
So first, capture some detailed diagnostics about the error
1) alter system set events '4030 trace name heapdump level 536870917;name errorstack level 3';
2) wait for the error to occur at least once
3) alter system set events '4030 trace name context off; name context off';
This will generate a trace file with extensive debugging information - you can then log a support call with Oracle to work through the issue.
And 11.2.0.1 is a very old, and very unpatched version.... You (a) really should be on 11.2.0.4 and (b) be looking at upgrading to a supported version!
Is this answer out of date? If it is, please let us know via a Comment