Home » Developer & Programmer » Data Integration » ORA-04021 in the middle of the night (Standard Edition Release 12.1.0.2.0 - 64bit Production)
ORA-04021 in the middle of the night [message #659437] Tue, 17 January 2017 03:13 Go to previous message
Buchas
Messages: 98
Registered: March 2006
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: oracle workflow login
Next Topic: ODI integrate with Golden Gate
Goto Forum:
  


Current Time: Thu Aug 06 14:46:51 CDT 2020