Re: V$, x$ to investigate the PGA?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 24 Nov 1999 19:22:02 -0000
Message-ID: <943471421.13364.0.nnrp-09.9e984b29@news.demon.co.uk>

You could try:

svrmgrl
connect internal
oradebug setospid {operating system process id of shadow} oradebug dump heapdump 1

This will give you a PGA heapdump in the trace file. You will probably find that there are lots of free blocks of 4K representing some sort of memory leak to do with cursors or sorting.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Reza wrote in message
<943460544.12870.0.nnrp-04.d4f07aaa_at_news.demon.co.uk>...
>Hi
>Could anyone help me find some information on what is stored in PGA of a
>user session. They keep growing Any v$ or x$ table to query?
>Thanks a lot for your help and time.
>Regards
>Reza
>
>
Received on Wed Nov 24 1999 - 13:22:02 CST