(Wolfgang genser) Do you want to know what are the blockers and what are the waiters? This SQL script was tested on 8i and 9i but was originally test on 7.3.4. It is very helpful in determining what is holding a lock and what is waiting for it. (R)(script)
Read More - Register for Free Membership
