What Is Wrong With This SQL?

Quick and easy method of finding which step in execution plan is causing problem. Plan statistics eliminate guess and pinpoint the operation where most of the time is spent during execution. Basic understanding of Oracle Explain plan output is required.

Full text »

Oracle Tuning Using Frequent SQL Statistics Snapshots (FSSS) Method

How to locate problem SQL more accurately and efficiently? The new FSSS method proved to outperform other methods in troubleshooting of real life production databases. The examples demonstrate FSSS method in action.

Full text »

Alternative "pipelined" presentation of query Execution plan

We all get used to Explain plan tree-like presentation. Is it always easy to read? Getting difficulties following the nested levels? There is another presentation, easier to follow, and by the way reflecting the pipeline nature of SQL statement execution.

Full text »

See also: