Monthly Archive: January 2010

Jan 17 2010

ORA-31098: Internal event to turn on XDB tracing

“Do not document”… …if not only due to that comment, it is a very interesting event, if not only that it seems that it is used for multiple items and not only tracing. I tried to figure out what I could do with this event regarding the XDB Protocol Server trying to figure out how …

Continue reading »

Jan 17 2010

Structured XMLIndex (Part 3) – Building Multiple XMLIndex Structures

You will probably never build only one structured XMLIndex. A practical use case would be an unstructured XMLIndex, indexing the semi-structured parts of your XML, multiple structured XMLIndexes, indexing the highly structured XML islands of data and maybe even a Oracle Text Context index indexing unstructured XML data. So the next example’s will show how …

Continue reading »

Jan 17 2010

Structured XMLIndex (Part 2) – Howto build a structured XMLIndex

As said in the “rule of numb” post, test your statement before you build an XMLIndex (structured or unstructured) on you column or table XML store. The database will check on the syntax you will use but NOT on the outcome. So if you statement doesn’t have the proper result set or is even empty, …

Continue reading »

Jan 17 2010

Structured XMLIndex (Part 1) – Rules of Numb

Its time to get rid of some backlog about Oracle 11gR2 XML DB features. Ones of them is about the new Structured XMLIndex or also called XMLIndex Structured Component. So in Oracle 11gR2 you have the ability to use a “unstructured” XMLIndex (UXI) and a “structured” XMLIndex (SXI). The use cases for these global index …

Continue reading »

Jan 17 2010

Updated XML(DB) Content

For my and your convenience, I have updated my “XML Content” page so it is a little bit easier to find the XML posts. There weren’t that many typical XML posts although I think the list has been added with another 20 post links. 2009 was a year with al lot of economic pressure (therefore …

Continue reading »

Jan 15 2010

Advert: Oracle XMLDB Masterclass in Germany

Here a small advert for one of my events scheduled for this year. On the 24th of Februari I will be giving a Masterclass regarding Oracle XMLDB in Germany. To be precise in Dusseldorf, Germany. The following will be addressed, but might you attend, then drop me a line (marco dot gralike at amis dot …

Continue reading »