Who locks who ? script needed

From: G Dahler <gd-nntp_at_spamex.com>
Date: Tue, 5 Apr 2005 15:14:32 -0400
Message-ID: <nuB4e.4954$6k4.485046@news20.bellglobal.com>

I used to use an rather expensive product to monitor locks on my database instances.

The product gives me a detailed view of "who locks who". For example, it can tell you that session 123 is waiting for sessin 456 which is itself waiting for session 789 to release a lock. It also tells me for how long session X waited for session Y.

It gives you the OS Server process ID as well, and it is now easy to call the user who did not commit it transaction to release the lock and let the other transaction proceed. You can kill the server process as well.

I guess a FREE product or script that does the same exists ?

I have seen various lock monitoring scripts, but none of them is easy to use or does exactly the same thing. We do not use OEM diagnostics pack either.

Thanks Received on Tue Apr 05 2005 - 14:14:32 CDT