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: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 Jul 2006 19:19:35 +0100
Message-ID: <a96dndaPko-oVCLZnZ2dnUVZ8qWdnZ2d@bt.com>


"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:qdhvb2tiseq7qa1u18j9n3m0rl6cpljamu_at_4ax.com...
> Is there are a way to ignore pga_aggregate_target for a batch job?
>
> We are running into running out of memory on a large job (still need
> to determine what it does)
>
> Oracle Version: 9.2.0.4.0
>
> Thanks
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3
> remove NSPAM to email

It is always possible to use a logon trigger to change session level parameters:

    alter session set workarea_size_policy = manual;     alter session set sort_area_size = ...     alter session set hash_area_size = ... etc.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Received on Thu Jul 20 2006 - 13:19:35 CDT

Original text of this message

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