RE: ORA-04030

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).