| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: relation shared pool elements phys mem
Tanel,
Thanks for replay,
Your suggestion can be the way to get the right information.
I am aware about x$ksmup & x$ksmpp unfortunately this is third party
application and we cant use those views.
The dumping can be the strategy.
.
I have found “Diagnosing and Resolving ORA-4030 errors” (Note 233869.1).
There is reference to the EVENT: 10261. It is seems that this event can be
useful for the purpose that we are discussing.
.
Are you aware, dose heapdump and 10261 works well in MTS env.?
.
Jurijs
On 08.08.2004 14:41:22 oracle-l-bounce wrote:
>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 Mon Aug 09 2004 - 02:54:15 CDT
 |
 |