Oracle Database - Actual (Runtime) Plan Statistics

Card Puncher Data Processing

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





Discover More
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN_STATISTICS_ALL

V contains memory usage statistics for row sources that use SQL memory (sort or hash-join). This view concatenates information in:...
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN_STATISTICS

V provides execution statistics at the row source level for each child cursor. STATISTICS_LEVEL Join Column Equality Predicate Join...
Card Puncher Data Processing
Oracle Database - V$SQLAREA

V displays statistics on shared SQL areas and contains: one row per SQL string. ie one row per cursor parent. It provides statistics on SQL statements that are in memory, parsed, and ready for execution....



Share this page:
Follow us:
Task Runner