创建索引被锁ora-00054资源正忙,但指定以nowait方式

SELECT sid, serial#, username, osuser FROM v$session where sid 
in(select session_id from v$locked_object);
--kill掉相关的会话
ALTER SYSTEM KILL SESSION '597,1171';
posted @ 2020-01-17 16:36  剑小新  阅读(2449)  评论(0编辑  收藏  举报