Stored Procedure Locks

From: Louis Cohen <louiscoh_at_sprynet.com>
Date: Fri, 1 Jan 1999 07:04:44 -0800
Message-ID: <76iosg$c3k$1@lore.eur.sprynet.com>

If I try to replace a stored procedure or package body with a new version while someone is using it, I get a message to the effect that the change timed out waiting for a lock.

I know how to identify who has a lock on a table or rollback segment (and even who is waiting for a lock on a table or rollback segment), but can anyone tell me how to identify which sessions have locks on stored procedures (and views as well, if possible)?

Please copy your reply to louiscoh_at_sprynet.com and/or lacohen_at_dreyers.com. The first useful answer, provided I haven't figured it out already myself, wins a couple of gift certificates for Dreyer's/Edy's Grand Ice Cream

Thanks/Regards

Louis Cohen
San Leandro, CA Received on Fri Jan 01 1999 - 09:04:44 CST