First page Back Continue Last page Overview Graphics

…V$SQL_PLAN_STATISTICS…

Notes:

The ADDRESS, HASH_VALUE and CHILD_NUMBER values uniquely identify the rows in V$SQL_PLAN_STATISTICS that we want to query.
The code in the slide is abbreviated. See the supplied script V$SQL_PLAN_STATS.SQL for a complete example of this code.