Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 17 2005 - 15:08:02 CDT
![]() |
![]() |