Oracle Database - V$SQL_PLAN

1 - About

V$SQL_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 V$SQLAREA cursor-specific information
ADDRESS, HASH_VALUE, and CHILD_NUMBER V$SQL child cursor-specific information

3 - Documentation / Reference

db/oracle/v_sql_plan.txt · Last modified: 2017/09/06 19:29 by gerardnico