Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what's the meaning of these message?

Re: what's the meaning of these message?

From: <denny_vk_at_hotmail.com>
Date: 1998/03/30
Message-ID: <6fo469$8bb$1@nnrp1.dejanews.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US