Stored Procedure Locks 
Author Message
 Stored Procedure Locks

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)?


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



Tue, 19 Jun 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ODBC Stored Procedure Locks in TEMPDB ???

2. Extended Stored Procedure locking up inside transaction

3. Stored Procedure locks tempdb

4. STORED PROCEDURE / LOCKING

5. Stored Procedure Locks

6. Stored procedure LOCK UP: BUG?

7. Stored procedure locks

8. Stored procedures locking behaviour

9. Calling a Java Stored Procedure from another Java Stored Stored Procedure

10. Row Locking In a Stored Procedure

11. Stored Procedure and Locking question?

12. Locked Stored Procedure


 
Powered by phpBB® Forum Software