ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

最新推荐文章于 2023-05-15 17:10:43 发布

spencer_tseng

最新推荐文章于 2023-05-15 17:10:43 发布

阅读量214

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/spencer_tseng/article/details/106722902

版权

oracle 专栏收录该内容

59 篇文章 0 订阅

订阅专栏

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 6月 12 19:33:00 2020

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> conn sys/oracle@orcl as sysdba
已连接。
SQL> select session_id from v$locked_object;

未选定行

SQL> SELECT sid, serial#, username, osuser FROM v$session WHERE sid = 1;

       SID    SERIAL# USERNAME                       OSUSER
---------- ---------- ------------------------------ ------------------------------
         1          1                                                        SYSTEM


SQL> SELECT session_id FROM v$locked_object;

未选定行

SQL> SELECT sid, serial# FROM v$session WHERE sid = 1;

       SID    SERIAL#
---------- ----------
         1          1

SQL> ALTER SYSTEM KILL SESSION '1,1'