First page Back Continue Last page Overview Graphics

V$SQL_PLAN Example

Notes:

V$SQL_PLAN view contains the plan that was used to execute a query. The ADDRESS and HASH_VALUE and CHILD-NUMBER columns uniquely identify a cached execution plan. These values are obtained from the V$SQL view. For example:
1 SELECT address, hash_value, child_number
2 FROM v$sql
3* WHERE sql_text like 'SELECT lastname, dept_name FROM employee e, department d WHERE e.dept_no = d.dept_no'
dave@DAVE> /
ADDRESS HASH_VALUE CHILD_NUMBER
-------- ---------- ------------
65E4D2E0 2053164708 0

See the supplied script V$SQL_PLAN.SQL for a working example.