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@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? Ron=20 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l