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 are so many great performance monitoring tools that have come along in the Oracle Database since 10g – things
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