Re: shared_pool_reserved_size and sga
- From: Ram Raman <veeeraman@xxxxxxxxx>
- To: Andreas Piesk <a.piesk@xxxxxxx>
- Date: Thu, 19 Aug 2010 17:30:40 -0500
Cursor_sharing has been similar all along. I thought cursor_sharing=force
was not a good idea at all, IIRC Wolfgang said that?
On Thu, Aug 19, 2010 at 5:19 PM, Andreas Piesk <a.piesk@xxxxxxx> wrote:
> Ram Raman schrieb:
> >
> > Thanks Andreas. All of them are cursors.
> >
>
> do you use cursor_sharing=similar? in my case some time i had to set
> cursor_sharing=similar because
> the application was not using bind variables at all. that solved one
> problem but introduced an
> other. after setting ursor_sharing=similar i noticed that every executed
> statement resulted in a new
> child cursor. we're talking about thousands of childs. setting
> cursor_sharing=force solved that problem.
>
> regards,
> -ap
>
>
Other related posts:
