Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 15700 invoked from network); 8 Aug 2007 13:47:44 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2007 13:47:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6760C724190; Wed, 8 Aug 2007 14:45:26 -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 15715-03-2; Wed, 8 Aug 2007 14:45:26 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFF2972367C; Wed, 8 Aug 2007 14:45:25 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 08 Aug 2007 14:03:19 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 37C86724A09 for ; Wed, 8 Aug 2007 14:03:19 -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 04555-05 for ; Wed, 8 Aug 2007 14:03:19 -0400 (EDT) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BE64572437A for ; Wed, 8 Aug 2007 14:03:17 -0400 (EDT) Received: by ug-out-1314.google.com with SMTP id o4so269721uge for ; Wed, 08 Aug 2007 11:05:32 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZQShVymYzUKQ3wRmLlnShghTkWnZfrVRFSo1ftD9bAAx2cLXJCWbz7xXy/YMnRqdD4RceG8es+Vyqjrozj50xaPTYxYxsnxnxnIBcIKRdWUGk/VgFZxnJEki/TP2vKsKhUyx5rqScoBO/Klp6gr//4WkyrS+cb0KSDskWx5QWJA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dtuSR0JlUV4IC4GYV/+GMxsMIurAUQ0GvuaORy1kVlgA6JSvCn2ghbLPzCcnl6dAFqFWSO6Rlta5dH377JpGRclKXb5hzdMo+qyJQ23kwC9IowmOgQP3kKouwHoTu6pkHoHn3y2nCEiBQoTl9z0cfrK8PIzAW04+u5M3G1DPS5U= Received: by 10.78.56.19 with SMTP id e19mr561322hua.1186596331595; Wed, 08 Aug 2007 11:05:31 -0700 (PDT) Received: by 10.78.163.19 with HTTP; Wed, 8 Aug 2007 11:05:31 -0700 (PDT) Message-ID: <4ef2fbf50708081105g1ee8614fod8aae7f3d49bad9b@mail.gmail.com> Date: Wed, 8 Aug 2007 20:05:31 +0200 From: "Alberto Dell'Era" To: afatkulin@gmail.com Subject: Re: sort latch usage in MTS mode Cc: zhuchao@gmail.com, oracle-l@freelists.org In-Reply-To: <49d668000708080946y5ba0b58fo6021052bbd5983a1@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <360443.48463.qm@web58705.mail.re1.yahoo.com> <2ba656800708061215n1d612ebey5a4d63174c61ee00@mail.gmail.com> <962cf44b0708080149o1d05e033i7cc253e8f308ec15@mail.gmail.com> <49d668000708080946y5ba0b58fo6021052bbd5983a1@mail.gmail.com> X-archive-position: 427 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: alberto.dellera@gmail.com Precedence: normal Reply-to: alberto.dellera@gmail.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 In fact note 30815.1"Init.ora Parameter SORT_AREA_RETAINED_SIZE Reference Note" says: "If the shared server is used, allocation is to the SGA until the value in SORT_AREA_RETAINED_SIZE is reached. The difference between SORT_AREA_RETAINED_SIZE and SORT_AREA_SIZE is allocated to the PGA." It's also true that the same note says "The default value as reflected in the V$PARAMETER dynamic performance view is 0. However, if you do not explicitly set this parameter, Oracle actually uses the value of the SORT_AREA_SIZE parameter." So by default the whole sort area is in the Large Pool; one could change this by explicitly setting SORT_AREA_RETAINED_SIZE. It seems that 223153.1only considers the default case. HTH Alberto On 8/8/07, Alexander Fatkulin wrote: > That's interesting since I always thought that it's sort_area_retained_size what is allocated from large pool and the rest (sort_area_size - sort_area_retained_size) is allocated out of the PGA still. > > Time for some checks indeed. > > > > > To Alex: > > sort will use large pool in MTS mode. Please check out metalink note 223153.1. It is very easy to reproduce/prove. -- Alberto Dell'Era "the more you know, the faster you go" -- http://www.freelists.org/webpage/oracle-l