Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 30443 invoked from network); 18 Jul 2007 18:28:08 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 18 Jul 2007 18:28:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 17054714F00; Wed, 18 Jul 2007 19:25:57 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28674-02-5; Wed, 18 Jul 2007 19:25:56 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF1D5714E97; Wed, 18 Jul 2007 19:25:55 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 18 Jul 2007 18:44:18 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F350D714A01 for ; Wed, 18 Jul 2007 18:44:17 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13470-04 for ; Wed, 18 Jul 2007 18:44:17 -0400 (EDT) Received: from outbound4-fra-R.bigfish.com (outbound-fra.frontbridge.com [62.209.45.174]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2810E714203 for ; Wed, 18 Jul 2007 18:44:16 -0400 (EDT) Received: from outbound4-fra.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound4-fra-R.bigfish.com (Postfix) with ESMTP id 5F3248D8D44 for ; Wed, 18 Jul 2007 22:46:26 +0000 (UTC) Received: from mail48-fra-R.bigfish.com (unknown [10.4.252.3]) by outbound4-fra.bigfish.com (Postfix) with ESMTP id 5DB7B85004B for ; Wed, 18 Jul 2007 22:46:26 +0000 (UTC) Received: from mail48-fra (localhost.localdomain [127.0.0.1]) by mail48-fra-R.bigfish.com (Postfix) with ESMTP id 47C972E021A for ; Wed, 18 Jul 2007 22:46:26 +0000 (UTC) X-BigFish: VP X-MS-Exchange-Organization-Antispam-Report: OrigIP: 12.41.53.16;Service: EHS Received: by mail48-fra (MessageSwitch) id 1184798786252764_3491; Wed, 18 Jul 2007 22:46:26 +0000 (UCT) Received: from dsmtpg02.col.discoverfinancial.com (unknown [12.41.53.16]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mail48-fra.bigfish.com (Postfix) with ESMTP id E0AFD9E8001 for ; Wed, 18 Jul 2007 22:46:25 +0000 (UTC) Received: from dsmtpg03.novus.relay (DSMTPG03 [12.41.53.14]) by dsmtpg02.col.discoverfinancial.com with ESMTP id l6IMh1N3023308 for ; Wed, 18 Jul 2007 18:43:07 -0400 Received: from dfscolm02.co.discoverfinancial.com (dfscolm02.co.discoverfinancial.com [199.12.96.170]) by dsmtpg03.novus.relay with ESMTP id l6IMnRs31992 for ; Wed, 18 Jul 2007 18:49:27 -0400 In-Reply-To: <49d668000707180920g655810c1q56a77a2e40ad2020@mail.gmail.com> Subject: Re: tunning an index build To: oracle-l@freelists.org Message-ID: From: genegurevich@discover.com Date: Wed, 18 Jul 2007 17:45:38 -0500 X-MIMETrack: Serialize by Router on DFSCOLM02/MSRV/DFSI(Release 7.0.1FP1|April 17, 2006) at 07/18/2007 17:45:31 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-archive-position: 51018 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: genegurevich@discover.com Precedence: normal Reply-to: genegurevich@discover.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Oops. Thank you. I have corrected that. I'll check and see if there is any improvement thank you so much Gene Gurevich "Alexander Fatkulin" "genegurevich@discover.com" Sent by: oracle-l-bounce@f cc reelists.org oracle-l@freelists.org Subject Re: tunning an index build 07/18/2007 11:20 AM Please respond to afatkulin@gmail.c om No, the pga_aggreagte_target is *only* relevant if you have workarea_size_policy=auto. What you have done is used the defaults for *_area_size which are quite small. On 7/18/07, genegurevich@discover.com wrote: > Alex, > > Yes, I have set pga_aggregate_target to 1.5G and workarea_size_policy is > manual. I thought that this will make > the sort_area_size (and all other area_size parameters) unused. IS that not > the case? > I am also working with the UNIX team to address the I/O contention that I > am seeing. > > thank you for your input > > > > Gene Gurevich -- Alex Fatkulin, The Pythian Group, http://www.pythian.com/blogs/author/alexf/ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l