RE: ORA-04030

  You get ORA-4031 when you cannot allocate space in the shared pool. ORA-4030 occurs when the process cannot allocate memory from the OS, due to insufficient memory or hitting the per process limit (maxdsiz) on memory. I would suggest reducing the size of the PL/SQL table to reduce memory usage.

Regards,
Denny

Quoting Stephane Faroult <sfaroult_at_oriolecorp.com>:

> 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: Denny Koovakattu
  INET: groups_at_koovakattu.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).