Oracle Database - Actual (Runtime) Plan Statistics

> Database > Oracle Database

1 - 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.


3 - Management

3.1 - View

4 - Configuration

If you want to capture the execution statistics:

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