locks on sysprocplan table ??? 
Author Message
 locks on sysprocplan table ???
I've been monitoring a procedure for performance and the last time I checked
onstat -u I noticed that instead of the normal 15 - 20 locks which are
generated by the procedure there were over 500 being held.  After further
investigation, I found that most of these locks were on the sysprocplan
table.

What is this table for, and why would the session have so many locks for
this table?

Thanks for you help.

Ben



Wed, 18 Jun 1902 08:00:00 GMT
 locks on sysprocplan table ???

Quote:

> I've been monitoring a procedure for performance and the last time I checked
> onstat -u I noticed that instead of the normal 15 - 20 locks which are
> generated by the procedure there were over 500 being held.  After further
> investigation, I found that most of these locks were on the sysprocplan
> table.

> What is this table for, and why would the session have so many locks for
> this table?

You have probably modified a stored procedure Dude. Try running:

update statistics for procedure

AB
----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. 100s of sysprocplan locks

2. Store procedures freezing on sysprocplan lock

3. sysprocplan and sysprocauth locks

4. Sysprocplan locked

5. SysProcPlan lock problem -211

6. sysprocplan locking problem

7. Lock problem with sysprocplan???

8. URGENT: Sysprocplan lock error - sqlcode=-211, ISAM=-144

9. SYSPROCPLAN locked using Stored Procedures

10. Sysprocplan locking and Stored Procs Recompiling

11. sysprocplan Locking?

12. SYSPROCPLAN locked using Stored Procedures


 
Powered by phpBB® Forum Software