Monthly Archive: October 2010

Oct 04 2010

HOWTO: Trace “ORA-19022: Unoptimized XML construct”

So you’re on 11.2.0.2.0 and you encountered in SQL*Plus this new feature “Unoptimized XML construct detected (enable XMLOptimizationCheck for more information)“. What can you do and how to get more info…? I encountered this new feature in SQL*Plus a month or so ago via the executing the following:   SQL> SET autotrace ON   SQL> …

Continue reading »