ora-00054:resource busy and acquire with nowait specified
當某個資料庫使用者在資料庫中插入、更新、刪除一個表的資料,或者增加一個表的主鍵時或者表的索引時,常常會出現ora-00054:resource busy and acquire with nowait specified這樣的錯誤。
主要是因為有事務正在執行(或者事務已經被鎖),所有導致執行不成功。
1、用dba許可權的使用者檢視資料庫都有哪些鎖
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time;
如:testuser 339 13545 2009-3-5 17:40:05
知道被鎖的使用者testuser,sid為339,serial#為13545
2、根據sid檢視具體的sql語句,如果sql不重要,可以kill
select sql_text from v$session a,v$sqltext_with_newlines b
where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value
and a.sid=&sid order by piece;
查出來的sql,如: begin :id := sys.dbms_transaction.local_transaction_id; end;
3、kill該事務
alter system kill session '339,13545';
4、這樣就可以執行其他的事務sql語句了
如增加表的主鍵:
alter table test
add constraint PK_test primary key (test_NO);
主要是因為有事務正在執行(或者事務已經被鎖),所有導致執行不成功。
1、用dba許可權的使用者檢視資料庫都有哪些鎖
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time;
如:testuser 339 13545 2009-3-5 17:40:05
知道被鎖的使用者testuser,sid為339,serial#為13545
2、根據sid檢視具體的sql語句,如果sql不重要,可以kill
select sql_text from v$session a,v$sqltext_with_newlines b
where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value
and a.sid=&sid order by piece;
查出來的sql,如: begin :id := sys.dbms_transaction.local_transaction_id; end;
3、kill該事務
alter system kill session '339,13545';
4、這樣就可以執行其他的事務sql語句了
如增加表的主鍵:
alter table test
add constraint PK_test primary key (test_NO);
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24558279/viewspace-712810/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00054: resource busy and acquire with NOWAIT specifiedUIAI
- ORA-00054: resource busy and acquire with NOWAIT specified處理UIAI
- ora-00054:resource busy and acquire with nowait specified解決方法UIAI
- "ORA-00054 resource busy and acquire with NOWAIT specified"的解決方法UIAI
- ORA-00054:resource busy and acquire with nowaitUIAI
- ORA-00054: resource busy and acquire with NOWAITUIAI
- oracle之 RA-00054: resource busy and acquire with NOWAITOracleUIAI
- ORA-00054,ORA-00031 resource busy and acquire with NOWAIT 資源佔用處理過程UIAI
- Oracle wait interface - ORA-00054: resource busyOracleAI
- gc buffer busy acquire問題處理GCUI
- open failed: EBUSY (Device or resource busy)AIdev
- ORA-00054: 資源正忙,要求指定 NOWAITAI
- Oracle ASM oracleasm createdisk "Device or resource busy"OracleASMdev
- 如何解決ORA-00054資源正忙,要求指定NOWAITAI
- oracle之報錯:ORA-00054: 資源正忙,要求指定 NOWAITOracleAI
- device-mapper create ioctl failed: Device or resource busydevAPPAI
- FILE ON OCFS CANNOT BE DELETED LINUX ERROR: 16: DEVICE OR RESOURCE BUSYdeleteLinuxErrordev
- oracle錯誤處理之ORA-00054:資源正忙,要求指定NOWAITOracleAI
- 分析解決11gR2 雙節點RAC環境下的gc cr block busy/gc buffer busy acquire等待GCBloCUI
- Linux rm -rf 之rm: cannot remove `linux': Device or resource busyLinuxREMdev
- ora-00054: 資源正忙, 但指定以 nowait 方式獲取資源如何解決AI
- ORA-00054: 資源正忙, 但指定以 NOWAIT 方式獲取資源, 或者超時失效AI
- gc buffer busyGC
- select for update nowaitAI
- for update和for update nowaitAI
- FOR UPDATE NOWAIT和 FOR UPDATEAI
- PMON failed to acquire latch, see PMON dumpAIUI
- No input file specified.
- Oracle Buffer Busy WaitsOracleAI
- buffer busy wait 解析AI
- oracle ora-00054錯誤處理Oracle
- Laravel Resource Routes和API Resource Routes講解LaravelAPI
- Bug 4632780 - PMON "failed to acquire latch" during shutdownAIUI
- PMON "failed to acquire latch" during shutdown-4632780.8AIUI
- PMON failed to acquire latch, see PMON dump in alert logAIUI
- mysql innodb之select for update nowaitMySqlAI
- Oracle中的for update 和 for update nowaitOracleAI
- 【譯】Resource Hints