SQL语句如下:
SELECT 'alter system kill session ' || '''' || sid || ',' || serial# || '''immediate;', a.*
FROM dba_ddl_locks a, v$session ss
WHERE a.name LIKE '%包名%'
AND a.session_id = ss.sid;
Oracle 查询被锁的包package
最新推荐文章于 2022-10-15 17:56:01 发布