ORA-00054: 資源正被使用中, 請設定 NOWAIT 來取得它, 否則逾時到期

1.查看被使用资源的OBJECT_ID

SELECT *FROM DBA_OBJECTS WHERE OBJECT_NAME='OBJECT_NAME'
2.查看资源被谁占用
SELECT * FROM V$LOCKED_OBJECT WHERE OBJECT_ID='591488'
3.杀掉进程
SELECT * FROM V$SESSION WHERE SID=24369
ALTER  SYSTEM KILL SESSION '24369,33469' IMMEDIATE
在系统中杀掉
SELECT * FROM V$PROCESS WHERE ADDR='0000002ABFB39368'

转载于:https://www.cnblogs.com/monkey6/p/10928845.html