SQL> select session_id from v$locked_object;
SESSION_ID
----------
542
1014
SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 542;
SID SERIAL# USERNAME OSUSER
---------- ---------- ------------------------------ ------------------------------
542 12783 HD40 admin
SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 1014;
SID SERIAL# USERNAME OSUSER
---------- ---------- ------------------------------ ------------------------------
1014 23373 HDAPP_02014 Administrator
SQL> select sql_text from v$session,v$sqltext_with_newlines where decode(v$session.sql_hash_value,0,prev_hash_value,sql_hash_value)=v$sqltext_with_newlines.hash_value and v$session.sid=&sid order by piece;
SQL_TEXT
----------------------------------------------------------------
INSERT INTO quan
oracle删表报错:ORA-00054 资源正忙
最新推荐文章于 2022-12-09 11:36:51 发布