Recent posts

Xplan: now with “self” measures for row source operations

One of the most useful information that the Oracle kernel attaches to plans in the library cache are measures of various resource consumption figures, such as elapsed time, consistent and current gets, disk reads, etcetera. These can be made available for each plan line (aka “row source...
Read more

Third International NoCOUG SQL & NoSQL Challenge!

For anyone into using their SQL skills creatively, and getting out of the boring SQL-coding daily routine … here is a puzzle that is both entertaining and challenging, and with a real prize for the winner! Official abstract: “In this challenge (see page 25), the Wicked Witch of the...
Read more

Tom Kyte in Italia – 5 Aprile 2011

Read more
Read more

Xtrace: an Oracle session trace browser – exec flow

Tracing a session is extremely useful when you need to investigate how a client interacts with the database – the client could be an application of yours, a third-party application, or an Oracle module such as dbms_stats or dbms_mview. To get the perfect picture of the client-server...
Read more

An improved OakTable web site

Today the new OakTable web site, www.oaktable.net, has been published: many thanks to Kurt Van Meerbeeck (that I’m told worked the most on the site), James Morle and Marco Gralike! I really like (besides the light and modern look) the aggregator of the OakTable members’ blogs –...
Read more