存储过程编译长时间卡死,最终ORA-04021: 等待对象锁超时,解决办法:
SYSTEM用户登录,查询锁定的用户对象,并kill相应进程。
select * from dba_ddl_locks where OWNER='DA';
select 'alter system kill session '''||sid||','||serial#||''';' from v$session where sid in (select session_id from dba_ddl_locks where owner='DA');
--alter system kill session '2058,27';
os一级杀进程orakill ORCL sid如orakill ORCL 2058