RE: Shared Pool Tuning

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 28 Sep 2004 15:06:14 -0400
Message-ID: <004501c4a58e$39670b50$8459000a@vttaxnet.tax.state.vt.us>

If you can't make it bigger right now, you can try flushing it periodically. This is not the permanent solution but it will work in the short run. You can run a job that flushes the shared pool every x hours.

HTH,
Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L. Sent: Tuesday, September 28, 2004 2:59 PM To: oracle-l_at_freelists.org
Subject: Shared Pool Tuning

Our shared pool is filling up and slowing down batch updates. Is there a way to correct this problem besides frequent commits, or enlarging the shared pool?

Ron=20
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 28 2004 - 14:02:39 CDT