Category: General
September 5

XMLDB Performance: Binary XML Storage Models

This post will show you some of the first numbers I collected regarding “Loading XML data”, while making use of different XMLType “physical storage containers”.

I also have done some initial testing with Object Relational XMLType storage, but because this method of storage has many options and extra features, I won’t describe them yet here. This topic is interesting enough to earn its on post.

If you need some background on Oracle XMLType Storage option than have a read through the “Binary-, CLOB, Object Relational Storage” Category option in the menu, the Oracle XMLDB Developers Manual or a short intro via Oracle 11g – XMLType Storage Options.

After having created an environment as described in “XMLDB Performance: Environment, Set-up, Procedure“, the following results were gathered by me while keeping values constant, for example the values for “connection.xml“, as described in the “XMLDB Performance: Environment, Set-up, Procedure” . Only the WIKI_STAGE create statements are different.

Read the postXMLDB Performance: Binary XML Storage Models
September 5

XMLDB Performance: Environment, Set-up, Procedure

There has some time past since my last update on my XMLDB Performance, tuning, adventure. As you maybe have read, I had my problems to set-up a decent test environment and loading XML data. I am testing with an Mediawiki XML dumpfile. If there is a problem or a side effect to notice than I have a big chance that it will show up if not only by the size of this Mediawiki XML dumpfile. The Mediawiki XML dumpfile contains, when I downloaded it, almost 8 million records and has a file size on Windows NT NFS of 17,4 Gigabyte.

Loading this data via the procedures described in my posts, “HOWTO: Load Really Big XML Files” and “Setting Up an XMLDB Performance “Baseline” Environment (Part 02)” dealt with some of the issues I encountered to realize controllable testing set-up. Loading this amount of XML data will take some time.

Read the postXMLDB Performance: Environment, Set-up, Procedure
August 25

My Schedule for Oracle Open World

Oracle Open World is near and I, more or less, finalized my schedule for Oracle Open World now. With the help of Doug’s schedule and from others, I filled in some blanks on Wednesday and Thursday.

I also saw that my session on Sunday, “Oracle XML DB: Building Blocks and Best Practices” and is almost full.

Sunday, Sep 21

10:30-11:30

Oracle XML DB: Building Blocks and Best Practices

Marco Gralike

My session on Wednesday with practical guidelines concerning working within the Oracle XMLDB boundaries, has still some seats available.

Tuesday, Sep 23

14:30-15:30

Real-World Experience with Oracle XML Database 11g: An Oracle ACE’s Perspective

Marco Gralike

Speaking about “Full“. Geoff Lee (Oracle)’s hands-on training sessions for “structured” storage are almost full and the hands-on training for “unstructured” have also only a few seats left. Be aware these are two different hands-on labs. One is dealing with Object Relational storage, the other one with (amongst others) binary XML storage structures…

An overview of all XMLDB related Oracle Open World sessions can be found on the following link: OTN XMLDB Forum OOW

I try to keep it updated… For instance, I added also the “Unconference” and “Oracle Mix Winners” related content.

Read the postMy Schedule for Oracle Open World