Oracle DBA

SQL Tuning & Execution Plans

Question

EXPLAIN PLAN versus an executed cursor plan: which evidence should guide tuning?

Answer

EXPLAIN PLAN is an optimizer prediction without execution. An executed cursor plan can expose actual rows, starts, and runtime behavior. Use the executed cursor plan for a live regression; use EXPLAIN PLAN for safe hypothetical checks.

This is 10 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples