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: [EMAIL PROTECTED]
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: [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).
