Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1336 invoked from network); 8 Aug 2007 12:29:20 -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 12:29:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 02A56722988; Wed, 8 Aug 2007 13:27:02 -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 26220-08; Wed, 8 Aug 2007 13:27:01 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5F90C7213FD; Wed, 8 Aug 2007 13:27:01 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 08 Aug 2007 12:44:25 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09AF172433D for ; Wed, 8 Aug 2007 12:44:25 -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 15407-08 for ; Wed, 8 Aug 2007 12:44:24 -0400 (EDT) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.184]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99A2F72169F for ; Wed, 8 Aug 2007 12:44:22 -0400 (EDT) Received: by mu-out-0910.google.com with SMTP id w8so256354mue for ; Wed, 08 Aug 2007 09:46:35 -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:references; b=E5RqD+l0Mm54E8Rzl0eYeV0VxsmVt63Q6n4+UoWLhBjId88eBCpmn/G0nHrW0qWeKZF50rkfZ09meXKVvJPk/NhEBorYdROUnKSTfN+/D1P0I0ElhySdOElD2T5HUjnZkUmxl9fPV22/krSb6wcsDhfOdwv3FMz3GD0x/vUmHRQ= 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:references; b=dEmmg5w9XquhE4+EMEFZspN1h8bXGVsj7A/tpW2tJhx32UCvd+vvpPpppc/x0CAlWB9obPZbgTy5IJ89eVA9pQg8zJYrRfIl9eWF5menep0a5n5Hz6BJSR1S1ffo+JDPLv2C8Uqorsu4G19tdt2512zW5XPZlVzEhurw99MZn34= Received: by 10.82.156.12 with SMTP id d12mr2143747bue.1186591595447; Wed, 08 Aug 2007 09:46:35 -0700 (PDT) Received: by 10.78.179.19 with HTTP; Wed, 8 Aug 2007 09:46:35 -0700 (PDT) Message-ID: <49d668000708080946y5ba0b58fo6021052bbd5983a1@mail.gmail.com> Date: Wed, 8 Aug 2007 12:46:35 -0400 From: "Alexander Fatkulin" To: zhuchao@gmail.com Subject: Re: sort latch usage in MTS mode Cc: oracle-l@freelists.org In-Reply-To: <962cf44b0708080149o1d05e033i7cc253e8f308ec15@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_81916_24971403.1186591595100" References: <360443.48463.qm@web58705.mail.re1.yahoo.com> <2ba656800708061215n1d612ebey5a4d63174c61ee00@mail.gmail.com> <962cf44b0708080149o1d05e033i7cc253e8f308ec15@mail.gmail.com> X-archive-position: 423 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: afatkulin@gmail.com Precedence: normal Reply-to: afatkulin@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 ------=_Part_81916_24971403.1186591595100 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. > > > > -- Alex Fatkulin, The Pythian Group, http://www.pythian.com/blogs/author/alexf/ ------=_Part_81916_24971403.1186591595100 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.


--
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/ ------=_Part_81916_24971403.1186591595100-- -- http://www.freelists.org/webpage/oracle-l