Queries involving Advanced Queueing Queue Tables which use the SYS.XMLTYPE within their ADT have a High Version Count
Last updated on JULY 07, 2012
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Oracle Server - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
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.
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