I am used to it with XMLDB, but apparently it is also applied on other Oracle functionality: new features being introduced while “only” applying a patch. Thanks to Doug, I was made aware on the whitepaper published by the Optimizer Development Group called “Upgrading from Oracle database 9i to 10g: What to expect from the optimizer”.
Comparing statistics
In 10.2.0.4.0 new DBMS_STATS functions have been introduced, that enable you to compare for a table from two different sources.
Just a small post here as a reminder how it can be applied: the use of namespaces in conjunction with the XMLQuery operator. A question came up on the OTN XMLDB Forum based on XMLQuery. After building a correct example XML file I needed the namespace reference within XMLQuery and it wasn’t easy to find so here, as a reminder, the comprised version.
See also post “Xquery Error – ORA19276” as a reference.
The processes going on as mentioned in post “Saving XML data directly to disk” got me thinking so I started testing. Why did the processes take 100% CPU time…? To be honest I still don’t know for sure (I suspect the assembling of the XML instance), because I am unsure if I didn’t mix up apples with oranges after all. I suspect there is maybe still an NLS conversion thing going on. I found the whole exercise interesting, also because it gave me a little bit more insight in the internals.
Follow me on my tracing adventure.
Bad Behavior has blocked 361 access attempts in the last 7 days.