Database/ORACLE

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

하늘색도화지 2019. 6. 27. 13:24
728x90

원인 : 처리대상 row가 lock상태일때 DBIO에 지정한 대기시간이 0이라 NOWAIT으로 바로 리턴되는 오류로 보통 ORA-03006과 함께 lock으로 인한 resource busy 오류로 판단

728x90