Up to this point, OEM has been very helpful in assisting us in tracking down errors. We've finally come across a problem that it doesn't lend itself to:
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 72 bytes (callheap,kcbtmal allocation)
ORA-04030: out of process memory when trying to allocate 72 bytes (callheap,kcbtmal allocation)
ORA-04030: out of process memory when trying to allocate 32 bytes (,callheap)
We get this error during an XML transform, using DBMS_XSLPROCESSOR.PROCESSXSL(…), in our 10.1.0.4 database. We've looked up this error on MetaLink and Google, and the solution is to increase PGA_AGGREGATE_TARGET (we're running DEDICATED servers).
This doesn't seem to solve the problem. In fact, our Developer/Analyst has some debug code in the program that indicates that this memory error is arising at the same volume of transformation, which we can vary in testing, despite doubling the value of PGA_AGGREGATE_TARGET.
Could someone help out with somewhere else we could start looking? We're using the DBMS_XML* and DBMS_XSL* packages in our code, and during their usage, is when the error is happening. Or, has someone experienced a resolution to this problem through an upgrade to 11Gr1?
Oracle 10.1.0.4
Red Hat Enterprise Linux AS release 4
--=cf