查询被锁的包



【查询被锁的包】
select *
from dba_ddl_locks
where name = 'PKG_PUBLICDATA_INIT_INTERFACE';
--根据sessionid查serialid
select t.sid,t.serial# from v$session t 
where t.sid=608;