relation shared pool elements phys mem 2004-08-09 - By J.Velikanovs@(protected)
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 (See ORA-4030.ora-code.com) 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.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
