RE: Memory taken by s session
Title: RE: Memory taken by s session 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 SKMCHRC = = = = = = = = = = = = = = = = = = = = -- 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).
Memory taken by s session
Title: Memory taken by s session 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 SKMCHRC
Re: Memory taken by s session
Take a look at v$sesstat for the statistics on pga and uga memory used hth connor --- Hussain Ahmed Qadri [EMAIL PROTECTED] 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 SKMCHRC = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
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 SKMCHRC = = = = = = = = = = = = = = = = = = = = -- 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).