Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: increasing open_cursors from 300 to 3000

RE: increasing open_cursors from 300 to 3000

From: Prem <premjhere_at_gmail.com>
Date: Fri, 21 Oct 2005 11:15:28 +0530
Message-ID: <56d3d5610510202245s2bb48911i32fc43f970006084@mail.gmail.com>


Hi Paula ,

As Larry said, starting with release 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



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On

Paula,

I heard after upgrading to 9.2.06 session_cached_cursors replaced open_cursors. Anybody else hear that?

Larry Wolfson
--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 21 2005 - 00:48:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US