Oracle Database - Actual (Runtime) Plan Statistics

About

The original Optimizer estimates are shown in the E-Rows (E stands for Estimate) column while the actual statistics of an actual plan gathered during execution are shown in the A-Rows column.

Management

View

Configuration

If you want to capture the execution statistics:

  • STATISTICS_LEVEL must be set to ALL.
  • The GATHER_PLAN_STATISTICS hint must be used

Powered by ComboStrap