truncate table plan_table;
EXPLAIN PLAN
SET STATEMENT_ID = ‘pvm’ FOR
select distinct owner, segment_name, segment_type
from dba_extents where file_id = &filid
and &blkid between block_id and block_id+blocks-1;
— syntax for viewing information from plan_table
SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position) “Query Plan”
FROM plan_table
START WITH id = 0 and statement_id = ‘pvm’
CONNECT BY PRIOR id = parent_id AND statement_id =’pvm’;