Oracle Database - V$SQL_PLAN

Card Puncher Data Processing

About

VSQL_PLAN contains the actual execution plan information for each child cursor loaded in the library cache.

A child cursor is a data result created from the same query (parent). The same query execution will create several child cursors in the library cache.

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|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 - Explain Plan from Cursor Cache (DBMS_XPLAN.DISPLAY_CURSOR)

This DBMS_XPLAN.DISPLAY_CURSOR function display the execution plan of an already executed statement where the resulting cursor...
Oracle Database Sga
Oracle Database - Session (Library|Cursor) Cache

The library cache is a part of the shared pool Private Sql Area Also known as: Session cursor cache. V contains the execution plan information for each child cursor loaded in the library...



Share this page:
Follow us:
Task Runner