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).
