Oracle Database - V$SQL_PLAN_STATISTICS

Card Puncher Data Processing

About

VSQL_PLAN_STATISTICS provides execution statistics at the row source level for each child cursor.

The parameter STATISTICS_LEVEL must be set to ALL in order to see data in this view.

Join Column Equality Predicate Join Table In order to add
ADDRESS and HASH_VALUE VSQLAREA cursor-specific information
ADDRESS, HASH_VALUE, and CHILD_NUMBER VSQL child cursor-specific information

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Actual (Runtime) Plan Statistics

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



Share this page:
Follow us:
Task Runner