Tag Archive: performance

Jan 07 2009

ADVERT: A 3 Day Oracle Performance MasterClass

Do you want to learn how to get your Oracle Database to perform better? Then you better be fast… There are only a limited amounts off slots still open for the  3 day Oracle Performance MasterClass with Cary Millsap and Jeff Holt from Method-R on 19, 20 & 21 of Januari in the Netherlands. The costs for this MasterClass …

Continue reading »

Oct 03 2008

A New Performance Blog…

I noticed that my colleague Gerwin Hendriksen created his personal (Oracle) performance related blog and put it online. Gerwin is doing a lot of research in general performance profiling called that resulted in the method called “GAPP”. One of the strong points of his method is that you are able to crossreference performance on all participating nodes …

Continue reading »

Sep 05 2008

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. …

Continue reading »

Jul 20 2008

XMLDB Performance: The Side Effects of a Simple “count(*)”

While setting up a baseline for my XMLDB performance tests, I noticed that my “count(*)” on a Binary XML table (using Securefile LOB storage) called “WIKI_STAGE” took an awful long time. So long, that I even had to kill the SQL*Plus session, that was executing the “count(*)”. I started wondering. Why did it take so …

Continue reading »