Re: increasing open_cursors from 300 to 3000
- From: Arul Ramachandran <contactarul@xxxxxxxxx>
- To: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
- Date: Fri, 21 Oct 2005 21:43:04 -0700
True. The increase was only a temporary measure until the code was fixed.
Arul
On 10/21/05, Kennedy, Jim <jim_kennedy@xxxxxxxxxx> wrote:
>
> While increasing from 255 to 500 isn't a problem, it isn't the solution is
> developers aren't closing cursors. It is just giving you a bigger pool to
> piss in. Some applications open a cursor and reuse it. That is fine. It is
> applications that open a cursor and leak them that is a problem.
> Jim
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Arul Ramachandran
> Sent: Fri 10/21/2005 6:05 PM
> To: Paula_Stankus@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: Re: increasing open_cursors from 300 to 3000
>
> Hi Paula,
>
> In the past with Oracle8i, I've increased OPEN_CURSORS (for ORA-1000)
> almost doubled from 255 to 500, without any negative side effects, as a
> temporary fix when developers rolled out Java code that did not close
> cursors. This helped us buy more time before we'd hit another ORA-1000, sort
> of treating the symptom.
>
> Arul
>
Other related posts:
