Explain plan en memoria | ExpoDBA

Explain plan en memoria

Explain plan en memoria

set linesize 163
set pagesize 1000
col operation format a40
 
select  b.id, b.operation ||' '||b.options operation, b.object_name, b.BYTES, b.cost, PARTITION_START, PARTITION_STOP, a.EXECUTIONS,a.child_number,b.parent_id
from V$SQL a, V$SQL_PLAN b
where
a.hash_value=b.hash_value and
a.hash_value='&numero' and
a.ADDRESS=b.ADDRESS and
a.CHILD_NUMBER = b.child_number
ORDER BY child_number, id;