Re: How windows manage memory: oracle

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

Physical memory and virtual memory overlap in windows.

If you have allocated 100M of memory, but only 50M of it is mapped to physical memory (rest is in pagefile), you see 100M and 50M accordingly in task manager.

Also, there is a situation where you can have more physical memory than virtual memory. Im not sure, but it might be doing something with deallocated memory, which is not reclaimed by OS or smth like that. There is a note about windows nt memory management in metalink, search from there if want additional information.

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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