Informix, locks on sysprocplan table ???

locks on sysprocplan table ???

Author	Message
Ben Drape #1 / 2	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

a_blo.. #2 / 2	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

Page 1 of 1

[ 2 post ]