RE: open_cursors

Frank

   Oracle Support once told me open_cursors could be very large - the default value is 50 which is quite small. I once tried making this larger and larger - Most of the time, sloppy developers need to close their open cursors. I have it set at 550 without any problem.

Mary Ruiz
Atlanta GA

-----Original Message-----
From: Frank.Dodgers_at_janus.com
Sent: Wednesday, September 27, 2000 12:42 PM To: Multiple recipients of list ORACLE-L Subject:

Dear List readers,

I got these messages in the alert log:

ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

OPEN_CURSORS is set to 400 for this instance which is on HP-UX 10.20. The Book
(ORACLE8i DBA Handbook) says that the value should be set to its maximum,
which
is OS dependent. Nice advice, except that I haven't been able to find the maximum value for HP-UX 10.2. Checked metalink and called Oracle Support, no
call back yet. We have already exceeded the 255 referenced in The Book. So,
I'm not sure how much higher to go at this point.

Any help will be greatly appreciated.

Frank

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Frank.Dodgers_at_janus.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).