My Oracle Support Banner

Select on Binary XMLwith Large CDATA Fails with an ORA-600 [qmcxdEvtNextcont] (Doc ID 1393786.1)

Last updated on JANUARY 20, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

In 11.2.0.2 and 11.2.0.3, a query on an XMLTYPE table with binary XML storage fails with an ORA-600 [qmcxdEvtNextcont]:


If the CLOB column CUSTOMER_NOTES which can contain > 8000 characters is excluded from the query, the error does not occur.

If the hint /*+ NO_XML_QUERY_REWRITE */ is used, the error does not occur, but the query runs for 45 minutes instead of the expected 5 minutes run time.

Changes

Database was upgraded from 11.2.0.1 to 11.2.0.2 or 11.2.0.3.

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