This discussion is archived
3 Replies Latest reply: May 17, 2013 4:02 PM by MarcoGralike RSS

Any way to limit memory which XSLT processor uses?

Pollocks01 Newbie
Currently Being Moderated
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE     11.2.0.3.0     Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
We use the xmltype.transform method to transform XSLT. We got oodles of memory (25Gb assigned to Oracle) but we do use a lot of that......

Is there a way to limit the amount of memory that the XSLT engine uses so as to avoid out of memory errors?
Errors in file /ora/oracle/diag/rdbms/prod01/PROD01/trace/PROD01_j001_16149.trc:
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
The XML file was just under 20Gb in size. I regularly see 10Gb xslt transformations using around 2Gb ram (via the top command on linux). I have no visibility to what the memory consumption was the time of the failure.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points