Re: relation shared pool elements phys mem
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 8 Aug 2004 14:41:22 +0300
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
