sqlplan.sql
Download Script
col query_plan for a60
accept hash_value number prompt 'Hash Value > '
select lpad(' ',2*(level-1))||operation||' '||' '||options||' '||object_name||' '||decode(id,0,'cost = '||position) query_plan, io_cost
from v$sql_plan
start with id = 1 and hash_value = &&hash_value
connect by prior id = parent_id and hash_value = &&hash_value;