Saturday, February 16, 2019

High cost sql_id's

select  sp.sql_id, object_owner, object_name, operation,cost,cardinality,cpu_cost,IO_COST
  from V$SQL_PLAN sp
 where /*operation = 'TABLE ACCESS'
   and options = 'FULL'
   and */object_owner not in ('SYS', 'SYSTEM', 'DBSNMP')
   and cost is not null
   order by cost desc, cpu_cost desc;

No comments:

Post a Comment