Thanks for the question, Md.Rahim.
Asked: January 11, 2020 - 11:33 am UTC
Answered by: Connor McDonald - Last updated: January 13, 2020 - 4:10 am UTC
Category: Database Administration - Version: 11.2
Viewed 100+ times
Dear Sir ,
Few Day i face Production Database Out of process memory Oracle Database Release 188.8.131.52.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 we 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 184.108.40.206 is a very old, and very unpatched version.... You (a) really should be on 220.127.116.11 and (b) be looking at upgrading to a supported version!