Re: increasing open_cursors from 300 to 3000
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: lawrence.wolfson@xxxxxxxxxx
- Date: Tue, 18 Oct 2005 02:21:10 -0400
On 10/17/05, Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx
> Sent: Monday, October 17, 2005 3:04 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
