Oracle Database - V

Card Puncher Data Processing

About

VSQL_PLAN_STATISTICS_ALL contains memory usage statistics for row sources that use SQL memory (sort or hash-join).

This view concatenates information in:

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

Documentation / Reference




Discover More
Card Puncher Data Processing
Oracle Database - (Actual|Final) Execution Plan

The actual or final plan is the execution that was executed in order to retrieve the result of a SQL. optimizerquery planrow source generator V view contains the actual plan for a query that...
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:...



Share this page:
Follow us:
Task Runner