Re: Poor performance w/ stored procedures

< What we're experiencing is that the performance for people using a stored
< procedure gets worse as the day goes on. We're eventually forced to shut
< down the database to clear out the SQLAREA in the SGA. Once this is done,
< the users run fine for a while then things start to slow again.

Have you checked out bug #242573 in Version 7.0 ? This one gave me a big headache. I posted details of this bug a couple of months ago under the subject: ORACLE7 reparses stored procedures all the time. Oracle gave us workarounds, such as "don't use synonyms, use real names," "Convert procedures to packages," etc. Those workarounds either did not work or took too much time to implement. Oracle did try to build a patch, but gave up due to the "complexity" of the problem.

-- 
							Yoichi Tamura
							y-tamura_at_nri.co.jp