ORA-04021 in the middle of the night [message #659437] |
Tue, 17 January 2017 03:13 |
Buchas
Messages: 101 Registered: March 2006
|
Senior Member |
|
|
Hello,
We have warehouse ETL(extract, transform, load) scripts running for ~8hours in the night. Sometimes in the middle of the night they crash with error "ORA-04021: timeout occurred while waiting to lock object" at random place. In the morning however the situation is gone - the statement which crashed with ORA-04021 at night, runs with no problems. How is it possible to know what (which session) is causing the crash? We can run some sqlplus script just after the crash, but what do we put inside?
Thanks in advance.
|
|
|