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 JULY 07, 2012

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Server - Enterprise Edition - 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 DEV_SOAINFRA.AQ$EDN_OAOO_DELIVERY_TABLE 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

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