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'