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

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Wed, 11 Jul 2001 05:50:30 -0700
Message-ID: <F001.00346D1F.20010711051633@fatcity.com>

> 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")

This kind of message is usually linked to a fragmented shared pool. Try to check which are the big packages which are reloaded most often (out of memory I do not remember which is the V$ view to check - something like V$CACHED_OBJECTS or similar - anyway, I know that there are scripts to do this on our site in the DBA toolkit section, and I am sure that you may find it elsewhere as well) and try in the future to have them pinned in memory (a trigger on startup, perhaps) to avoid fragmentation. Once you have identified these packages, a (very) short term fix may be ALTER SYSTEM FLUSH SHARED_POOL. And increasing the size of your shared pool is probably something to do as well. Like with almost anything else, any new version means more memory, more packages, more stuff in tablespace SYSTEM ...

Regards,

Stephane Faroult
Oriole
Corporation

---

Performance tools for Oracle ®
http://www.oriole.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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 Wed Jul 11 2001 - 07:50:30 CDT