Hi,
I explored the view v$sesstat. What I wanted to ask was whether the column VALUE in this shows bytes or what? Because if it is bytes then I can make out from combining the two views, i.e. v$sesstat and v$statname as to how much memory (pga, uga) is taken by every session. What I forgot to mention earlier was that we are using MTS. The PGA memory and maximum PGA memory remains more or less the same for every session opened, but UGA memory changes with some work. But even that is not consistent, I mean UGA memory doesn't always change with every query I run from that session. Any explanation as to why?
Regards,
Hussain
-----Original Message-----
From: chao_ping [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 22, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Memory taken by s session
Hussain Ahmed Qadri,
hi, from oracle, you can get it from v$sesstat, in oracle9i ,you can even get the more detailed data from v$process.
From Unix os, for solaris, you can use pmap, on linux, you can use /proc/<spid>/status. FOr other os, I hope others can share there experience.
Good luck
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org(China Oracle User Group)
======= 2003-03-22 00:13:00 ,you wrote£º=======
>Hi all,
>
>Can anyone tell me what is the memory any session takes when it logs on to
>the database? That's is, when a person opens a SQL plus window, how much
>memory is allocated to that session (just opening it and then the session is
>idle). And when he performs certain query, which returns over a few thousand
>records or more, what is the effect on the memory usage of that session. Any
>guidelines perhaps?
>
>Regards,
>
>DBA
>SKMCH&RC
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
