performance - oracle 11g 中的查询错误

Question

当我在 oracle 11g SQL*Plus 中执行此查询时，我的 session 挂起:

SQL> 
 declare maxid number;

 begin

  delete from  measure_details
 where id in (select id from general_measures  where code in ('12345','12346'));

 delete from general_measures
 where code in (select code from general_measures  where code in ('12345','12346'));

 end;
 /

Answer 1

如果它“挂起”，那么这可能意味着您尝试删除的一个或多个行被另一个 session 中的未提交事务锁定 - 甚至可能是您自己的另一个 session ？