Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: relation shared pool elements phys mem
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.
-- 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