Category: Performance
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 29

Oracle XMLDB Related “Events”

Undocumented stuff is always very interesting, although there is of course a reason why it is undocumented… Event settings are more or less in this category. They are often used by Oracle Support in their quest to do a good job solving our problems.

Sometimes events disable or enable features. Sometimes they trace internal processes. The later can be very helpful like setting the infamous “10046” event. I noticed some event settings that can be helpful while using XMLDB or the Protocol Server.

Here a small overview of some events that are in the manuals or mentioned during discussions on the OTN XMLDB Forum… Be careful while “playing” with these events. Some are mentioned in the XMLDB Developers Guide and not an big issue, others can cause very strange results or abnormal behavior.

So be advised…

Read the postOracle XMLDB Related “Events”
July 30

Setting Up an XMLDB Performance Baseline Environment (Part 02)

Hmmm, still busy to setup a baseline environment to do some serious XMLDB performance / architecture testing. I am almost now on the point were I really can start, but until now I ran into a lot of issues… It also told me that the mediawiki dumpfile is good set of XML data to work with. A lot of variance is build in. I hope I won’t encounter too muchmore issues though…

Read the postSetting Up an XMLDB Performance Baseline Environment (Part 02)