RE: Shared Pool Tuning

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>, <rlsmith@xxxxxxx>
  • Date: Tue, 28 Sep 2004 15:06:14 -0400

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.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Smith, Ron L.
Sent: Tuesday, September 28, 2004 2:59 PM
To: oracle-l@xxxxxxxxxxxxx
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?



Other related posts: