sql tuning – Learning is not a spectator sport

I did not write this blog post

In fact…no-one wrote this blog post! Here’s a little bit of fun for you. I was doing my normal doom

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

For pretty much as long as I can remember, the view V$SESSION_LONGOPS has existed. It has a suite of columns

I happened across an interesting thread on Twitter today which posed the question about when you should intervene with alternative

There is a million books, blogs, presentations etc about SQL Tuning. But it’s time for a different perspective. SQL Tuning

I’m a big fan of giving developers the tools they need to tune their applications in Production if that is