Re: pga_aggregate_target and temp tablespace extent sizing

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 19 Jun 2004 00:20:22 -0700
Message-ID: <42fc55dc.0406182320.3029c856@posting.google.com>

Have you tried AskTom? A lot of discussion there related to your question such as this one:

http://asktom.oracle.com/pls/ask/f?p=4950:8:14719454541585402174::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:5554598997115,

Regarding your sort performance "which you're not happy about", how large is your PGA_AGGREGATE_TARGET? If you perform large sorts and this is not sufficient then your response time will really be terrible. A check on your multipasses will be helpful.

jbradshaw777_at_yahoo.com (John) wrote in message news:<f2f59d82.0406181248.2a1eec0d_at_posting.google.com>...
> Hi,
> I have been searching around for info. regarding pga_aggregate_target
> and temp tablespace extent sizing. Does anybody have any more updated
> info. on this? I saw a thread from about 2 years ago which indiacted
> that 5% of pga_aggregate_target is the maximum fraction a process can
> claim and may be the right size for temp tablespace extent. I am not
> happy with the sorting performance on my server and suspect temp
> tablespace extent sizing may not be appropriate. Can anybody share?
>
>
>
> John
Received on Sat Jun 19 2004 - 02:20:22 CDT