UPDATE 语句在存储过程中卡死

1、事务未提交导致的锁等待 

   SELECT l.session_id, l.locked_mode, l.object_id, o.object_name
   FROM v$locked_object l JOIN all_objects o ON l.object_id = o.object_id;

2、索引问题 

   SELECT index_name, column_name
   FROM user_ind_columns
   WHERE table_name = 'table';