Tomorrows presentation at AMIS, will be my first test run for my UKOUG presentation in December, Birmingham. It took me a while to get the red herring from my braincells onto a Powerpoint presentation. To be honest, I am still not really pleased with it. It lacks some coherency, but I almost now for sure that it will be there when I start of and introduce my audience into the wonderful (sometimes confusing) world of XMLDB.
I will address a lot of DBA viewpoints on to the matter.
Read more…
After a lot of guess work and some fiddling around, I got the first steps figured out. There is only one entry, one reference, but this gave me a first step in the “right” direction…
Click on the picture to enlarge
Cool stuff (have a look).
😎
Learned yesterday an important lesson on the Oracle OTN XMLDB forum. A question was asked why a count via a full table scan was quicker than the same example while using an XMLIndex. “XMLIndex performance regarding // (any descendant))”. The poster used the // xpath expression to do his search.
As in most cases nowadays it is important to keep your statistics in order. An XMLIndex is not an “index” as such, it is an logical index / domain index, specially designed for use with XMLDB / XML data.
Read more…
Bad Behavior has blocked 328 access attempts in the last 7 days.