objects locked wrt lock ids
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/08/12
Message-ID: <40gtm7$8dp_at_homer.alpha.net>#1/1
Date: 1995/08/12
Message-ID: <40gtm7$8dp_at_homer.alpha.net>#1/1
Is it possible to figure out which object is locked by a particular lock id from v$lock table. v$access tells me which objects are locked by a particular SID; and v$lock tells me which locks are held by an SID. I want to know for an SID the lock ids that it has and which object is locked by that lock id.
thanks
-- **************************************************************Received on Sat Aug 12 1995 - 00:00:00 CEST
* Saad Ahmad *
* McHugh Freeman & Associates, Inc. *
* Ph: (414) 798-8606 Ext. 457 *
* Fax: (414) 798-8619 *
* E-Mail: sahmad_at_mfa.com *
**************************************************************