RE: ORA-01000: maximum open cursors exceeded

Catherine,

Setting this to a higher value generally does not hurt badly. On a heavily used 10.7 system, this is currently set to 512 with no problems. I have seen larger values before - 600 comes to mind...

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: CHAN Chor Ling Catherine (CSC) [mailto:clchan_at_nie.edu.sg]
> Sent: Sunday, March 31, 2002 7:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-01000: maximum open cursors exceeded
>
>
> Hi Gurus,
>
> Every week, we do a logical export of the whole production
> database. It used
> to work until I encounter the "ORA-01000: maximum open
> cursors exceeded"
>
> Command : exp userid='system/system_pwd' file=$ORA_EXP_FILE
> grants=y rows=y
> constraints=y compress=y full=y inctype=complete log=$ORA_EXP_LOG
> Error message :
> Connected to: Oracle8i Enterprise Edition
> Release 8.1.6.1.0
> - Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
> Export done in US7ASCII character set and US7ASCII NCHAR
> character set
>
> About to export the entire database ...
> . exporting tablespace definitions
> EXP-00008: ORACLE error 604 encountered
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
> EXP-00000: Export terminated unsuccessfully
>
> Qn :
> * Before exporting, we startup the database in restrict
> mode. Is it
> the same for you gurus out there ?
> * If I were to increase the cursor, how many should I increase to
> (Current value=300) ?
>
> Please help. TIA
>
> Regds,
> New Bee
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
> INET: clchan_at_nie.edu.sg
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).