How windows manage memory: oracle

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: chao_ping_at_vip.163.com

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: ListGuru_at_fatcity.com (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).