....there is no such thing as failure, only learning experiences.
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