Oracle Database - Actual (Runtime) Plan Statistics

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
db/oracle/actual_statistics.txt ยท Last modified: 2017/09/06 19:30 by gerardnico