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:chao_ping_at_163.com
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

• = = = = = = = = = = = = = = = = = = =