My Oracle Support Banner

Queries involving Advanced Queueing Queue Tables which use the SYS.XMLTYPE within their ADT have a High Version Count (Doc ID 1473494.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Queries of the form

select (sysdate-enq_time) * 86400, msg_state from <Schema>.<Table_name> where msg_id =...

have high version counts.

As per the cursor trace events discussed in <Note 296377.1> the trace file for the relevant sql_id the reason for the sharing failure is related to anydata transformation

SQL pgadep:1 pgapls:1 user
 kksUnlockChild: releasing child
 Failed sharing : 80000000 <<<<<<<<<<<<<<<<<<<<<<<<<< anydata transformation

The underlying queue tables for the associated queries have ADTs which utilise sys.xmltype.

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.