Re: locks on sysprocplan table ???

---- you wrote: > 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