读书人

resource busy and acquire with NOWA

发布时间: 2012-07-25 09:43:06 作者: rapoo

resource busy and acquire with NOWAIT specified: TRUNCATE TABLE "USERS"

SQL> select session_id from v$locked_object;


SESSION_ID---------- 43
SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 43;


SID SERIAL# USERNAME---------- ---------- ------------------------------OSUSER------------------------------ 43 8907 SXITISMGtssx

SQL> ALTER SYSTEM KILL SESSION '43,8907';


System altered.

读书人网 >网络基础

热点推荐