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

Home -> Community -> Usenet -> c.d.o.server -> Re: way to ignore pga_aggregate_target for a batch job?

Re: way to ignore pga_aggregate_target for a batch job?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 20 Jul 2006 18:38:05 GMT
Message-ID: <h4Qvg.174701$F_3.89781@newssvr29.news.prodigy.net>


NetComrade wrote:
> Is there are a way to ignore pga_aggregate_target for a batch job?

Connect using shared server (MTS)

>
> We are running into running out of memory on a large job (still need
> to determine what it does)

It eats memory.

-- 
Mladen Gogala
http://www.mgogala.com
Received on Thu Jul 20 2006 - 13:38:05 CDT

Original text of this message

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