Re: what's meaning of these messages ?

From: Jing Shen, sj_at_china.pages.com.cn >> SVRMGR> _at_new
create or replace package body upd163 as *
ORA-04031: unable to allocate 73968 bytes of shared memory ("unknown object","PL/SQL MPCODE","BAMIMA: Bam buffer") <<

You are hitting one or two problems:
1) There is an absolute limit to the size of a package. How many lines a package can be depends on the code since different statements use different amounts of memory. It seems to me that it is somewhere around 128k 2) To compile adds additional memory requirements to a package and through 7.3 this space must be contigueous within the shared pool.   Possible fixes are:
1) You can try flushing the shared pool with 'alter system flush shared_pool;' a couple of times then re-compiling
2) Increase the shared pool size via init.ora and bounce system 3) Break the package up into several smaller packages which will need less memory to compile.

Versions 7.2.0 and 7.2.1 had several bugs related to the shared pool and memory management.

I hope this helps.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Mon Mar 30 1998 - 00:00:00 CEST