niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Server
way to ignore pga_aggregate_target for a batch job?
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
Author Message
NetComrade
*nix forums Guru Wannabe


Joined: 24 Mar 2005
Posts: 241

PostPosted: Thu Jul 20, 2006 6:07 pm    Post subject: way to ignore pga_aggregate_target for a batch job? Reply with 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
Back to top
Jonathan Lewis
*nix forums Guru


Joined: 23 Apr 2005
Posts: 376

PostPosted: Thu Jul 20, 2006 6:19 pm    Post subject: Re: way to ignore pga_aggregate_target for a batch job? Reply with quote
"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
Joel Garry
*nix forums Guru


Joined: 24 Mar 2005
Posts: 1044

PostPosted: Thu Jul 20, 2006 6:27 pm    Post subject: Re: way to ignore pga_aggregate_target for a batch job? Reply with quote
NetComrade wrote:
Quote:
Is there are a way to ignore pga_aggregate_target for a batch job?

I think you can just turn it off for the session.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1222.htm

Jonathan Lewis on his site has some examples of how to play with
pga_aggregate target, personally when I've had problems I just voodoo
cut everything in half and mumble about the docs being misleading.
There may be bugs in 9204 too.

http://www.google.com/search?hl=en&lr=&q=pga_aggregate_target+site%3Awww.jlcomp.demon.co.uk&btnG=Search

To be honest, I use the OEM advisor and it seems to work OK in general
once things are close. The voodoo stuff is just at setup (ie, add
another instance and suddenly, you're swapping - Wasn't that a Martha
and the Motels song?).

jg
--
@home.com is bogus.
http://www.youtube.com/watch?v=5WQJb9a3co8
Back to top
Mladen Gogala
*nix forums Guru


Joined: 11 Mar 2005
Posts: 948

PostPosted: Thu Jul 20, 2006 6:38 pm    Post subject: Re: way to ignore pga_aggregate_target for a batch job? Reply with quote
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
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
The time now is Mon Dec 01, 2008 8:10 pm | All times are GMT
navigation Forum index » Databases » Oracle » Server
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts convert a dos batch file into perl without using any modu... king Perl 1 Fri Jul 14, 2006 2:04 pm
No new posts how to edit a batch file king Perl 4 Fri Jul 14, 2006 1:56 pm
No new posts [netqmail] ignore STARTTLS for certain hosts or configure... Lars Uhlmann Qmail 1 Thu Jul 13, 2006 1:02 pm
No new posts Number of consecutive failures allowed in batch job? alyciac@aol.com VMS 10 Wed Jul 12, 2006 7:23 pm
No new posts How do I tell Aptitude to Ignore a Broken Package? Jeff Stevens Debian 1 Tue Jul 11, 2006 5:20 am

Adverse Credit Remortgage | Mortgage Calculator | Loans | Quick Collect | Buy Anything On eBay
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2760s ][ Queries: 16 (0.1894s) ][ GZIP on - Debug on ]