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: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 17 Oct 2005 16:03:41 -0400
Message-ID: <82F7EDC10657264083BF52FBC64378CE02C0350E@dohsmailhq07.doh.ad.state.fl.us>


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.    

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 17 2005 - 15:08:02 CDT

Original text of this message

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