What about session UGA memory? Do where name like 'session %ga%');
Yechiel Adar Mehish ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 3:24 PM > Hi, friends: > Several months ago there is a thread talking about choosing the proper memory size for windows server running oracle. > And today I logon to one of my small oracle on NT and found something I cannot understand. It is a small application running Oracle 817/win2k. > SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from task manager, Oracle is using 1005M physical Memory and 1013M virtual memory(you can view the data from here: > http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif). > > > > SQL> show sga > > > > Total System Global Area 971040796 bytes > > Fixed Size 75804 bytes > > Variable Size 299798528 bytes > > Database Buffers 671088640 bytes > > Redo Buffers 77824 byte > > SQL> select count(*) from v$session; > > > > COUNT(*) > > ---------- > > 18 > > SQL> select sum(value) from v$sesstat where statistic#=(select statistic# from v$statname where name='session pga memory max'); > > > > SUM(VALUE) > > ---------- > > 39526196 > > And I looked at another server running SAP/oracle, get similiar data: > > http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif > > (780M sga,33 connection and 25M pga). > > > > Can someone explain it? > > > > Regards > > > > Zhu Chao. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: zhu chao > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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).