From oracle-l-bounce@freelists.org Thu Oct 6 10:57:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j96FvNM2028833 for ; Thu, 6 Oct 2005 10:57:28 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j96FuNvX028503 for ; Thu, 6 Oct 2005 10:56:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D45B21F46E1; Thu, 6 Oct 2005 10:55:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24404-06; Thu, 6 Oct 2005 10:55:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A2A61F4B31; Thu, 6 Oct 2005 10:55:31 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=bMtLm3avWc0dl+zjBGjz5yOVmZ2u32hgfK5VBJMWp90MMA6GetdOnNw6cuw+Y+JchepnOm9VovKt/q/U7gKfvgmBNg0wRS/B5cgEsBzMuufc9fnOMlsmct65mwNg3jfbKiXmTb0Qkjp2tazzsuZ1jfIZoFNfB2uSUD5S7Z5sCW8= Message-ID: <23e0d1170510060853k240e8446n13f0bea851f199ac@mail.gmail.com> Date: Thu, 6 Oct 2005 17:53:21 +0200 From: Giovanni Cuccu To: joe_dba@hotmail.com Subject: Re: pga_aggregate_target question Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23533_2917260.1128614001985" References: X-archive-position: 26461 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: giovanni.cuccu@gmail.com Precedence: normal Reply-To: giovanni.cuccu@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_23533_2917260.1128614001985 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Joe, Jonathan Lewis wrote an article about pga settings that could answer your questions. http://www.jlcomp.demon.co.uk/snark.html Hope this helps, Giovanni On 10/6/05, Joe Smith wrote: > > If you set the parameter pga_aggregate_target and sort_area_size does > oracle > still use the sort area size parameter? > > I have looked on metalink and in Chris Lawson's lastest book. I have yet > to > see a definative answer. > > thanks. > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's FREE= ! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > http://www.freelists.org/webpage/oracle-l > -- -------------------------------------------------------------------- Another free oracle resource profiler http://sourceforge.net/projects/oraresprof/ New version 0.8 with many bug fixes and warnings on file truncated, timed_statistics=3Dfalse, incorrect tracing deactivation and more ------=_Part_23533_2917260.1128614001985 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Joe,
   Jonathan Lewis wrote an article about pga settings that could = answer your questions.
http://www.jlcomp.demo= n.co.uk/snark.html
Hope this helps,
   Giovanni

On 10/6/05, <= b class=3D"gmail_sendername">Joe Smith <joe_dba@hotmail.com> wrote:
If you set the parameter pga_aggregate_target and sort_area_size does oracl= e
still use the sort area size parameter?

I have looked on metali= nk and in Chris Lawson's lastest book.  I have yet to
see a de= finative answer.

thanks.

____________________________________________________= _____________
Express yourself instantly with MSN Messenger! Download to= day - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

= --
http://www.free= lists.org/webpage/oracle-l



--
----------------------------------------------------------------= ----
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
New version 0.8 with many bug fixes
and warnings on file truncat= ed, timed_statistics=3Dfalse, incorrect tracing deactivation and more
------=_Part_23533_2917260.1128614001985-- -- http://www.freelists.org/webpage/oracle-l