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.

• A Rows: Output Rows from VSQL_PLAN_STATISTICS
• A time
• Buffers

Articles Related

Management

View

• VSQL_PLAN_STATISTICS_ALL: SQL execution runtime statistics for cached SQL cursors

Configuration

If you want to capture the execution statistics:

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