Oracle Database - V$SQL_PLAN_STATISTICS

> Database > Oracle Database

1 - About

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

3 - Documentation / Reference