Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: what's the meaning of these message?
Hi,
That means that there is not enough continuous free memory in your SGA. Flush the SGA using
alter system flush shared_pool;
and try again.
Denny
In article <6fnt2a$2on$1_at_nnrp1.dejanews.com>,
sj_at_china.pages.com.cn wrote:
>
> Hello :
>
> I am now compiling a PL/SQL procedure (5127 lines ,131358 characters).
>
> before I load it normally in svrmgrl , using @new
>
> but , from this afternoon , I can't ,
> the messages is :
>
> $ svrmgrl
>
> Oracle Server Manager Release 2.3.3.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed and Spatial Data options
> PL/SQL Release 2.3.3.0.0 - Production
>
> SVRMGR> connect sj
> Password:
> Connected.
> SVRMGR> @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")
> SVRMGR>
>
> Is this means I should enlarge the unix parameter os shared memory ? or
swap
> disk ?
>
> Thank you very much!
>
> Jing Shen
>
> Mail to: sj_at_china.pages.com.cn
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 30 1998 - 00:00:00 CST