My Oracle Support Banner

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

Last updated on SEPTEMBER 12, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.