Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!newsmst01b.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr30.news.prodigy.com.POSTED!a25fe021!not-for-mail From: Mladen Gogala Subject: Re: Optimizing Database Productivity User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table) Message-Id: Newsgroups: comp.databases.oracle.server References: <1126010561.298013.21240@f14g2000cwb.googlegroups.com> <1126019821.413669.238810@g44g2000cwa.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Lines: 16 NNTP-Posting-Host: 69.177.129.16 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr30.news.prodigy.com 1126383360 ST000 69.177.129.16 (Sat, 10 Sep 2005 16:16:00 EDT) NNTP-Posting-Date: Sat, 10 Sep 2005 16:16:00 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: TSU[@IONRZU]RVXXOBCBNWX@RJ_XPDLMN@GZ_GYO^JWTEPIB_NVUAH_[BL[\IRKIANGGJBFNJF_DOLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA@X_DCBHXR[C@\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^@SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN Date: Sat, 10 Sep 2005 20:16:00 GMT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251260 On Tue, 06 Sep 2005 08:17:01 -0700, Mark D Powell wrote: > Actually even if pga_aggregate_target is in use I am pretty sure you > should still set a value for sort_area_size as there are some > situations where this value will be still be used. I saw this > demonstrated in a post by Jonathan Lewis recently where he was pointing > out the error in a posted article at a "self-proclaimed" expert site. Wow, not that again! Emotions were flying pretty high on Tom's blog in that thread, hopefully no flame war will be ignited here. -- http://www.mgogala.com