Oct 04 2010
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> …
Oct 16 2008
Nowadays, this “Collection Iterator Pickler Fetch” output in an explain plan is less and less seen as the XML database functionality becomes more and more stronger in re-writing statements. Alas, I got one, again. SQL> xquery 2 let $auction := ora:VIEW("XM_TAB") RETURN 3 COUNT( 4 FOR $i IN $auction/site/closed_auctions/closed_auction 5 WHERE $i/price/text() >= 40 6 …
Recent Comments