sql – Learning is not a spectator sport

Listener log data mining with SQL

If you take a look at the log files created by the listener, there is obviously a nice wealth of

I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I

We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL

A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in

OK, let’s be honest right up front. The motivation for this post is solely to be able to roll out

In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a

Most developers tools out there have some mechanism to unload a table into a flat file, either as CSV, or

There are plenty of blog posts about using the pre-processor facility in external tables to get OS level information available

It’s a holiday here today in Perth, so a very brief blog post because I’ve been busy doing other things