| ORA-04030 with PL/SQL java calls to CAPSCAN [message #91386] |
Mon, 05 August 2002 03:54  |
Nigel Rayson
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
We are have an Oracle 8.1.7 database on Windows 2k. We run a PL/SQL package that calls a geocoding product CAPSCAN via Oracle's jvm. The package essentially assigns a full address to a record. After 10,000 records the package fails with:
SQL> exec cmg_cris.a00_process_whole_batch;
BEGIN cmg_cris.a00_process_whole_batch; END;
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 27052 bytes (joxcx
callheap,ioc_allocate free)
ORA-04030: out of process memory when trying to allocate 16420 bytes (pga
heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 16524 bytes (pga
heap,ksm stack)
ORA-06512: at "DIANE_PROCESS.DIANE_UTILS", line 1018
ORA-06512: at "DIANE_PROCESS.CMG_CRIS", line 2154
ORA-04030: out of process memory when trying to allocate 16396 bytes (pga
heap,ksm stack)
ORA-06512: at line 1
Are there any known memory leak problems for Capscan and or the Oracle jvm
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
