XMLSERIALIZE QUERY = ORA-4030 (KOLARSCREATECT,QMEMNEXTBUF:LARGE ALLOC) (Doc ID 1568372.1)

Last updated on SEPTEMBER 12, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

This query:

  SELECT     d.id,
             a.valueprimitive,
             b.aspect,
             a.modified,
             'st4',
             xmlSerialize (DOCUMENT a.data AS CLOB)
    FROM     isxml a,
             isxmlvprel b,
             isxmldv c,
             isxmlndrel d
    WHERE    a.data IS NOT NULL
    AND      a.valueprimitive = b.valueprimitive
    AND      b.datavalue = c.datavalue
    AND      c.dataclass IN (7145014, 307638, 535205)
    AND      d.datavalue = c.datavalue
    ORDER BY d.id, b.aspect ASC;

fails in SQL*Plus with this error:

  ERROR:
  ORA-04030: out of process memory when trying to allocate 65576 bytes
  (kolarsCreateCt,qmemNextBuf:Large Alloc)

 

Errors in the alert log include:

     ORA-04030: out of process memory when trying to allocate 1049112 bytes
     (pga heap,log read buffer)
     ORA-04030: out of process memory when trying to allocate 65576 bytes
     (kolarsCreateCt,qmemNextBuf:Large Alloc)

     ORA-04030: out of process memory when trying to allocate 824504 bytes
     (pga heap,kco buffer)

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