From oracle-l-bounce@freelists.org Sun Aug 8 06:37:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i78Bb9v24906 for ; Sun, 8 Aug 2004 06:37:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i78Bb9I24901 for ; Sun, 8 Aug 2004 06:37:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6622972C213; Sun, 8 Aug 2004 06:27:43 -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 17958-57; Sun, 8 Aug 2004 06:27:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF46C72C1A9; Sun, 8 Aug 2004 06:27:42 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 08 Aug 2004 06:26:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8885172C1E4 for ; Sun, 8 Aug 2004 06:26:20 -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 17102-80 for ; Sun, 8 Aug 2004 06:26:20 -0500 (EST) Received: from MXR-5.estpak.ee (ld3.estpak.ee [194.126.101.102]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3483B72C1C9 for ; Sun, 8 Aug 2004 06:26:20 -0500 (EST) Received: from porgand (217-159-134-237-dsl.kvm.estpak.ee [217.159.134.237]) by MXR-5.estpak.ee (Postfix) with SMTP id A049747A3E for ; Sun, 8 Aug 2004 14:41:27 +0300 (EEST) Message-ID: <041d01c47d3c$a39865c0$9c969fd9@porgand> From: =?windows-1257?Q?Tanel_P=F5der?= To: References: Subject: Re: relation shared pool elements phys mem Date: Sun, 8 Aug 2004 14:41:22 +0300 MIME-Version: 1.0 Content-type: text/plain; charset=windows-1257 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at neti.ee X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 7162 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi! > But still not enough for telling that is the root cause of leaking. > Can any body add some hints to the list? Where is this leak occurring? In your user process? If you can execute diagnostic queries within your application, you might get somewhat more detailed information by querying PGA or UGA heap statistics tables: select ksmchcom, ksmchcls, ksmchsiz from x$ksmup; -- UGA heap select ksmchcom, ksmchcls, ksmchsiz from x$ksmpp; -- PGA heap The ksmchcom shows you some information about to whom was the allocation made.. As an alternative you can sample heapdumps (level 1 for PGA summary and 4 for UGA summary) of the leaking process and see which areas tend to grow.. Tanel. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------