RE: CURSOR_SPACE_FOR

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 26 Jun 2003 10:47:22 -0700
Message-ID: <F001.005BA8B4.20030626102446@fatcity.com>

Do you have the bug number?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]

-----Original Message-----
Sent: Thursday, June 26, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L

We are ran into a bug the other day where oracle dumps core with a ORA-07445 error. We tracked it down to a Context related bug where PL/SQL callout during heavy shared pool load cause the ora-07745 core dump. The suggested workarounds are to set CURSOR_SPACE_FOR_TIME to true. This is in 8.1.7.4.0 and is reportedly fixed in 9i. What are listers experience with this parameter? On our system it sound like setting this without altering the size of the shared pool would be potentially dangerous and could cause more problems that leaving it alone.

This error is not a critical one to business functions and users here. (so far)

Thanks

Brad Odland
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Odland, Brad
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net
--

Author: Gogala, Mladen
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: CURSOR_SPACE_FOR_TIME