Re: increasing open_cursors from 300 to 3000

On 10/17/05, Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com> wrote:
>
> Paula,
>
> I heard after upgrading to 9.2.06 session_cached_cursors
> replaced open_cursors.
>
> Anybody else hear that?
>
>
> Larry Wolfson

Larry,

Refer to README for 3501955, regarding "PL/SQL Cursor Caching". This was the 9.2.0.5.0 patchset.

Paul

> ________________________________
>
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Paula_Stankus_at_doh.state.fl.us
> Sent: Monday, October 17, 2005 3:04 PM
> To: oracle-l_at_freelists.org
> Subject: RE: increasing open_cursors from 300 to 3000
>
>
>
>
> We are running with about 500 concurrent users.
>
> O racle Version 9.2.0.6
>
> Solaris 2.9
>
> 0RA-1000 "Too many open cursors" error when selecting from a sequence over a
> dblink.
>
> Metalink Note:238407.1 describes the error and indicates that the bug id is
> corrected in 9.2.0.3 and later. We're running 9.2.0.6.
>
> A nyone have any advice or head's up when increasing open_cursors
> significantly. I would think that if these open cursors are used then there
> might be memory issues.
>
>
>
>
>
> **************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
> **************************************************************************
>
>

--
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l