Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Objects destruction

Re: Objects destruction

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Mon, 21 Aug 2000 21:03:27 -0700
Message-ID: <qXmo5.9993$p5.383834@nntp1.onemain.com>

You need to increase your SGA. Increase your shared_pool_size in your init.ora file and stop and restart Oracle. Jim
"agis_at_diax" <agis_at_dplanet.ch> wrote in message news:39A1154C.EF605973_at_dplanet.ch...
> Hi
>
> We are running a lot of PL/SQL code and are also using Objects. When we
> do a big transaction, we get an error message "out of process memory...
> (pga heap, ksm stack)".
> We think it might have to do with our objects, as there are constructors
> for them, but there seems to be no deconstructor. Oracle also said that
> they don't do any garbage collection. Does somebody know how I get the
> memory from my objects freed.
>
> Thanks
> Hanspeter
>
Received on Mon Aug 21 2000 - 23:03:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US