Hi all,

Can someone share some tips on how to check for blockers and lockers and how to
come up to the conclusion on which process or session to kill to resolve or
free up the lock or locks that is causing the bottleneck on my database that is
giving record in use or block in use error messages?

Is there any way to check if the process had hung for a long time and and for
how long that it has become what is normally referred to as a runaway process
or zombie process?

Thanks in advance.


Oracle LazyDBA home page