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
   On 10/20/05, Prem <premjhere_at_gmail.com> wrote:
>
> Hi Paula ,
>
> As Larry said, starting with release 9.2.0.5 <http://9.2.0.5>, the
> SESSION_CACHED_CURSORS
> initialization parameter now determines the upper bound for PL/SQL cursor
> caching instead of OPEN_CURSORS initialization parameter.
> For more info', refer README for patch # 3948480.
>
> Regards,
> Prem Khanna J
>
>

--
http://www.freelists.org/webpage/oracle-l