locks on sysprocplan table ???

Posted in 2000

Ben Draper — Mon, 12 Jun 2000 16:19:04 -0400 — source: Informix-list mailing list archive (1991-1998)

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 aregenerated 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

Related threads

record locked
who locks a record?