Thanks Andreas. All of them are cursors. On Thu, Aug 19, 2010 at 4:47 PM, Andreas Piesk <a.piesk@xxxxxxx> wrote: > Ram Raman schrieb: > > Querying shared_pool_reserved view after the bounce an hour ago shows us > > that the request failures is 28. Our sga target is 4.5Gb now. > > i had a similar problem some time ago. which part of shared_pool grows? > > -ap >