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