如何用sql profile 找出执行慢的sql

2025-03-24 12:15:59
推荐回答(1个)
回答1:

  原SQL语句如下:
update Tindex a set a.object_type='SPECIAL' where a.object_type is not null
and exists (select 1 from Tindex b where b.object_name='TINDEX'
and a.object_name=b.object_name)
  使用以下语句查看当前游标执行计划,和预期的不一样
select * from table(dbms_xplan.display_cursor('55j33gdu4qx7g'));

用explain plan fo