Re: How windows manage memory: oracle

That is utterly disgusting memory management. When I come to think of it, there was a guy named David Cutler who was promising that Windows will have the same virtual memory system as VMS, with FREELIM,FREEGOAL, BORROWLIM, GROWLIM and MPW_ parameters. Working sets are also gone as well as the most elaborate privileges system until that time. Authorize was a wonderful tool which still leaves anything that either windows or Unix can offer in the dust.
On 12/04/2003 02:54:31 PM, Tanel Poder wrote:
> > 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).
>

Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.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).