Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: Help: shared mem prob, PL/SQL, WebServer
Re: Help: shared mem prob, PL/SQL, WebServer
The problem is that the shared pool portion of the SGA is too fragmented
in small "chunks".
Execute the following statement from Server Manager:
ALTER SYSTEM FLUSH SHARED_POOL;
Hope this helps.
Michael Serbanescu.
Steve Kappel wrote:
>
> Oracle 7.3.2, WebServer 2.1, Solaris 2.5.1, Ultra 2/2170 with
> 128MB RAM and over 300MB free swap
>
> I'm getting intermittant errors in production indicating that
> there isn't enough shared memory available. The errors are
>
> OWS-05101: Agent : execution failed due to Oracle error 6500
> ORA-06500: PL/SQL: storage error
> ORA-04031: unable to allocate 4092 bytes of shared memory ("unknown object","PLS
> non-lib hp","plbtn: keys & data/ptrs")
>
> and
>
> OWS-05101: Agent : execution failed due to Oracle error 4031
> ORA-04031: unable to allocate 6448 bytes of shared memory ("HTF","PL/SQL MPCODE"
> ,"BAMIMA: Grow Bam Buffer")
> ORA-06508: PL/SQL: could not find program unit being called
>
> My shared_pool_size is set to 9000000 (supposedly a "LARGE" scenario).
> The system shared mem max is 134217728.
>
> These errors can happen immediately after restarting Oracle and
> the WebServer. The PL/SQL code that the first one refers to
> is a function call with just a few arguments. The application
> is relatively small (amount of code, number of tables,
> amount of data, and number of users).
>
> Any hints on how to debug this further??
>
> --
> ______________________________________________________________________
> Steve Kappel steve.kappel@iname.com http://www.visi.com/~skappel
Received on Mon Sep 08 1997 - 00:00:00 CDT
Original text of this message