Re: MemoryStatistics of a session

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 5 Jul 2002 20:58:50 +1000
Message-ID: <jTeV8.28063$Hj3.86493@newsfeeds.bigpond.com>

Hi Srihari,

V$SESSTAT (session pga memory, session pga memory max), V$SESSION_WAIT, V$SESSION_EVENT and V$MYSTAT have so many goodies to get yourself stuck into, I get all excited just thinking about it !!

They should give you a good idea on what your session's up to.

Good Luck

Richard
"Srihari" <hari_avar_at_yahoo.co.uk> wrote in message news:1cbd197f.0207050202.1c1afe13_at_posting.google.com...
> Hi
>
> Iam using a procedure which has a group of nested cursors with top
> level cursor fetching around 150 rows of data & about 10 rows per each
> of 4 inner cursors.Its working fine at our place But I have a doubt
> If it affects the performance at customer installations.
> Is there any method to find the memory utilised by a user session
>
> Thanx in advance
>
> Srihari
Received on Fri Jul 05 2002 - 05:58:50 CDT