Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1373 invoked from network); 8 Aug 2006 09:58:33 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 09:58:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED7353BD964; Tue, 8 Aug 2006 10:58:15 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01637-01-3; Tue, 8 Aug 2006 10:58:15 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 412AD3BD9C6; Tue, 8 Aug 2006 10:58:14 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 10:57:04 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5C1483BD8CC for ; Tue, 8 Aug 2006 10:57:04 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01354-01-4 for ; Tue, 8 Aug 2006 10:57:04 -0400 (EDT) Received: from smtp4.poczta.interia.pl (smtp10.poczta.interia.pl [80.48.65.10]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66D5C3BD9AA for ; Tue, 8 Aug 2006 10:57:01 -0400 (EDT) Received: by smtp4.poczta.interia.pl (INTERIA.PL, from userid 502) id 64B94374625; Tue, 8 Aug 2006 16:57:14 +0200 (CEST) Received: from poczta.interia.pl (mi04.poczta.interia.pl [10.217.12.4]) by smtp4.poczta.interia.pl (INTERIA.PL) with ESMTP id 0ADDD374622 for ; Tue, 8 Aug 2006 16:57:14 +0200 (CEST) Received: by poczta.interia.pl (INTERIA.PL, from userid 502) id 5F864143928; Tue, 8 Aug 2006 16:57:10 +0200 (CEST) Received: from [192.168.211.111] (przymorze2a.nsm.pl [195.34.211.148]) by poczta.interia.pl (INTERIA.PL) with ESMTP id 3DCD614390F for ; Tue, 8 Aug 2006 16:57:10 +0200 (CEST) Message-ID: <44D8A680.4010007@interia.pl> Date: Tue, 08 Aug 2006 16:58:08 +0200 From: Grzegorz Goryszewski User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: sort_area_retained_size bigger than sort_area_size and memory leak ? Content-Type: text/plain; charset=ISO-8859-2; format=flowed X-EMID: a51b2acc X-archive-position: 37878 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: grzegorzof@interia.pl Precedence: normal Reply-to: grzegorzof@interia.pl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net Hi, on one of ours SF890 (Solaris 9 20GB RAM ,20GB swap) with oracle 8.1.7.4 32-bit installed. We experiencing memory leak, there is less and less swap space from 20GB free to almost 0 in 5-6 days. There is no obvious reason why is that, I mean no large memory allocations by processes, even oracle v$sesstat for' %ga memory' value looks pretty normal (max 9MB pga for process, but total ~2GB). There is about 500 oracle session , SGA size defined as 1,8GB. The only parameter which focused my attention was sort_area_retained_size = 30M and smaller sort_area_size =1,5M . Is there any reason for memory leak with such 'anomaly' ? Frankly speaking Im out of any other ideas. Any suggestions ? Best Regards. Grzegorz Goryszewski ---------------------------------------------------------------------- PS. Fajny portal... >>> http://link.interia.pl/f196a -- http://www.freelists.org/webpage/oracle-l