3 Replies Latest reply: May 17, 2013 6:02 PM by Marco Gralike RSS

    Any way to limit memory which XSLT processor uses?

    Pollocks01
      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.