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


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


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