oracle 存储过程卡无法编辑

 --1.根据存储过程名查相应的sid,serial#
select session_t.*, ddl_locks.*
  from v$session session_t, dba_ddl_locks ddl_locks
 where session_t.sid = ddl_locks.session_id
   and session_t.status = 'ACTIVE'
   and ddl_locks.name = upper('p_test');
  --2.结束相应的会话 需在拥有权限的账号下执行，假设 sid,serial# 为156，3443
  alter system kill session '156,3443' immediate ;
  --3.重新打开存储过程进行编辑