RE: ORA-04030

Stephane,

   I don't think it's a Shared pool fragmentation problem.

   I believe the process (the foreground process) can't allocate enough memory to do its processing. May be because some kernel parameters are not correctly defined (ie: max_d_size, if I remember correctly, in HP) or just because the process is filling a big array and it can't get enough memory to finish the task. (as Fermin has suggested).

   In order to classify the problem as a shared pool frag. problem he should have gotten a ORA 4031 error.

Pls correct me if I'm wrong

HTH
Greetings
Diego Cutrone

John,

   This looks like a classic example of shared pool fragmentation. The reactive way to handle this is to flush it (ALTER SYSTEM ...). The proactive way is to use the DBMS_SHARED_POOL.KEEP procedure to pin (usually at startup - can be done in a trigger) the biggest and most heavily used packages (check V$DB_OBJECT_CACHE - or such a name) in memory so that they stay there and do not mess things up by being reloaded umpteen times. SYS packages usually are among the first candidates.

HTH Stephane Faroult

>----- ------- Original Message ------- -----
>From: John Dunn <john.dunn_at_sefas.co.uk>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Thu, 24 Apr 2003 01:56:39
>
>We get the error :
>ORA-04030 out of process memory when trying to
>allocate 16396 bytes
>(koh-kghu sessi, kol vstring)
>ORA-06512: at "SYS.DBMS_SYS.SQL", line 917
>ORA-06512: at "SYS.DBMS_SQL", line 120
>ORA-06512: at line 194
>Version is 8.1.7.0.0
>Any one any advice on avoiding this error?

-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051
http://www.fatcity.com
San Diego, California        -- Mailing list and web
hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an
E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be removed
from).  You may
also send the HELP command for other information (like subscribing).

------------
¡Navegá y ayudá a un chico!
Por cada usuario que se conecte a Internet 
con Yahoo! Conexión en abril, Yahoo! Argentina 
donará un plato de comida para un niño, a través 
de la asociación "Por los chicos".
http://ar.online.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Diego=20Cutrone?=
  INET: diegocutrone_at_yahoo.com.ar

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).