Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: relation shared pool elements phys mem

Re: relation shared pool elements phys mem

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Sun, 8 Aug 2004 14:41:22 +0300
Message-ID: <041d01c47d3c$a39865c0$9c969fd9@porgand>


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_at_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
-----------------------------------------------------------------
Received on Sun Aug 08 2004 - 06:37:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US