Re: ORA-04030

Diego,

  You are absolutely right. I had missed on 'process memory'. Could use MTS to make it become ORA-4031 :-).

  John, the reference to DBMS_SQL points to dynamic SQL inside your PL/SQL code. Any idea about what it does ?

SF

Diego Cutrone wrote:
>
> 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_oriole.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).