JSP Using JFreeCharts Fails With ora-7445 [SIGSEGV] and ora-4030 (joxp heap,f:MMAN) (Doc ID 853331.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4
This problem can occur on any platform.

Symptoms


Java Stored Procedure using JFreeCharts does not release PGA memory consumed and fails with the following errors after successive runs
ORA-07445: exception encountered: core dump [0000E864] [SIGSEGV]
ORA-04030: out of process memory when trying to allocate 2011464 bytes (joxp heap,f:MMAN)

Example of code used:

declare
v_image_blob blob;
v_ctype number := 1;
v_header varchar2(256) := 'Test chart';
v_yvalue varchar2(50) := 'Test values';
begin
v_image_blob := JAVA_TEST.GENERATE_CHART.GENERATE_CHART(v_ctype, v_header, v_y
value);
end;

After a few runs, we can see pga joxp heap growing:

---> HEAP DUMP heap name="pga heap" desc=0xce76aa0

BreakDown
~~~~~~~~~
Type Count Sum Average Percent
~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
Free(heap.awk) 2216 70498920 31813.59 45.56
joxp heap 2429 83998048 34581.33 54.28

---> HEAP DUMP heap name="joxp heap" desc=0xeb33b48

BreakDown
~~~~~~~~~
Type Count Sum Average Percent
~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
f:MMAN 2189 72453016 33098.68 86.31
f:OldSpace 60 8410272 140171.20 10.02
f:SST 16 131904         8244.00   0.16 

select sid,name,value
from
v$statname n,v$sesstat s
where
n.STATISTIC# = s.STATISTIC# and
name like 'session%memory%'
and sid=144;

SID NAME VALUE
---------- ---------------------------------------------------------------- --
144 session uga memory 549412
144 session uga memory max 1690708
144 session pga memory 203148356
144 session pga memory max 204524612

SQL> /

SID NAME VALUE
---------- ---------------------------------------------------------------- --
144 session uga memory 549412
144 session uga memory max 1733420
144 session pga memory 784649284
144 session pga memory max 785763396


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms