SQL para mostrar as instrucoes que tendem a ter mais impacto no seu banco:

spool SQL_DELINQUENTE.LOG
col c1 heading ‘ID’ format a13
col c2 heading ‘Custo’ format 9,999,999
col c3 heading ‘Texto SQL’ format a200
select p.sql_id c1,p.cost c2,DBMS_LOB.SUBSTR(s.sql_text,4000,1) c3
from dba_hist_sql_plan p,dba_hist_sqltext s
where p.id = 0and p.sql_id = s.sql_id
and p.cost is not null
order by p.cost desc;

spool off