Recent posts

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

Xtrace: an Oracle session trace browser (introduction)

Xtrace is a graphical tool that can navigate Oracle trace files, manipulate them, and optionally get them back as a text file. It actually makes (much) more, but in this first post we are going to focus on its basic browsing capabilities. Let’s see the tool in action on the trace file produced...
Read more