Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:
I ran 1000 open_cursors on Solaris, if that is any help.....
>From: Frank.Dodgers_at_janus.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: Wed, 27 Sep 2000 08:42:23 -0800
>
>
>
>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).
Share information about yourself, create your own public profile at Received on Wed Sep 27 2000 - 12:45:20 CDT
![]() |
![]() |