| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Help: shared mem prob, PL/SQL, WebServer
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/~skappelReceived on Mon Sep 08 1997 - 00:00:00 CDT
 |
 |