Real time scenario which I faced

Hi
Error: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 

https://community.oracle.com/thread/2552670

http://abeytom.blogspot.in/2012/08/finding-and-fixing-ora-00054-resource.html