RE: unable to allocate 4096 bytes of shared memory

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Wed, 11 Jul 2001 09:16:16 -0700
Message-ID: <F001.0034751E.20010711084056@fatcity.com>

There is a bug in 8.1.7 in which the connect/disconnect causes a memory leak in the shared pool. You need to patch to 8.1.7 and then apply a bug fix. Not
sure what the bug number is but its up there on the ftp site. It took me approximately
10 hours to get the first page regarding this issue after the upgrade. Course,
if they provided me with a test box we would have found the bug before moving
it to production. I am a little bitter about the whole thing still.

-----Original Message-----
Sent: Wednesday, July 11, 2001 6:12 AM
To: Multiple recipients of list ORACLE-L

John,

Increase the Shared_Pool_Size parameter in the INIT.ORA file, and restart the database.
I would suggest an increase of at least 50%.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, July 11, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L

We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as follows :

It appears to be related to dbms_job

Can any one help?

John

Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc: ORA-12012: error on auto execute of job 11223917

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","SERVER
_PRINTER_RESET","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1
Sun Jul 8 23:52:14 2001
Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp1_19492_prtgh1.trc:

ORA-12012: error on auto execute of job 11227622 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","SERVER
_RECEPTION","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1

--

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

Author: John Dunn
INET: john.dunn_at_sefas.co.uk

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: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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: Kimberly Smith
INET: kimberly.smith_at_gmd.fujitsu.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: unable to allocate 4096 bytes of shared memory - HELP!!!!