| Author |
Message |
Mladen Gogala
*nix forums Guru
Joined: 11 Mar 2005
Posts: 948
|
 Posted: Thu Jul 20, 2006 6:38 pm Post subject:
Re: way to ignore pga_aggregate_target for a batch job?
|
|
|
NetComrade wrote:
| Quote: | Is there are a way to ignore pga_aggregate_target for a batch job?
|
Connect using shared server (MTS)
| Quote: |
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 |
|
| Back to top |
|
 |
Joel Garry
*nix forums Guru
Joined: 24 Mar 2005
Posts: 1044
|
|
| Back to top |
|
|
Jonathan Lewis
*nix forums Guru
Joined: 23 Apr 2005
Posts: 376
|
| Posted: Thu Jul 20, 2006 6:19 pm Post subject:
Re: way to ignore pga_aggregate_target for a batch job?
|
|
|
"NetComrade" <netcomradeNSPAM@bookexchange.net> wrote in message
news:qdhvb2tiseq7qa1u18j9n3m0rl6cpljamu@4ax.com...
| Quote: | 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 |
|
| Back to top |
|
|
NetComrade
*nix forums Guru Wannabe
Joined: 24 Mar 2005
Posts: 241
|
| Posted: Thu Jul 20, 2006 6:07 pm Post subject:
way to ignore pga_aggregate_target for a batch job?
|
|
|
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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
