ORA 4031 Error Occuring With Large shared_pool_size = 200 MB

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 11 Jul 2002 11:24:58 -0800
Message-ID: <F001.004957C4.20020711112458@fatcity.com>

At a production Site Following Error Occuring many Times Daily Now the init ora parameters are according to what was suggested. the Shared pool is 200M. Still we are getting the following error: Message : 002: DATABASE ERROR - sqlcode = [-9999] Operation: [S] Message - [scr_udf.cxx,3508](OCI:ofen):[-18]:Error during record fetch,(ORA-0403 1: unable to allocate 4176 bytes of shared memory ("shared pool","unknown object ","sga heap","library cache"))
Oracle 8.1.7.2.0
AIX 5.1
Machine eServer P690 regatta

Qs What could be the Solutions to the Above ? Could this be BUG Number 1397603 Fixed in some Higher Patch Version ?

Seemingly Setting _db_handles_cached to 1 from the default Value of 5 is a Workaround . _db_handles_cached = Buffer handles cached each process

Question - Is the parameter Safe to Set ? Once Set , while unsetting the Same is there anything that needs to be Done ?

NOTE -
NO Trace Files Dumped in the USER_DUMP_DEST & BACKGROUND_DUMP_DEST NO Error messages in alert_$SID.log
cursor_sharing=EXACT

Thanks

--

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

Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.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). Received on Thu Jul 11 2002 - 14:24:58 CDT