Re: How windows manage memory: oracle
Thanks Paul. I did a check this week with out Win2000 tech support and was told that it come with 3GB process size while WNT was limited to 2GB (without special parameters). What is this pslist command? Is it something from Unix? Yechiel AdarMehish - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Thursday, December 04, 2003 7:34 PM Subject: Re: How windows manage memory: oracle Hi. The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024. its between 1.7 and 1.8 GB. I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4. W2K3 Server (not Advanced) ships with large memory support. In Windows 2000, one needed to acquire Advanced Server edition for large memory support. ways that you know that you hit the process memory limit: 1. unable to startup instance 2. unable to spawn a dedicated server process (in listener.log) 3. unable to allocate n bytes of memory in the shared pool (in the user's error message) For tracking memory usage by a process (namely, oracle.exe), I'd recommend using the sysinternals pslist utility, and log that to an OS file. There is the performance logs option in the OS, which gives you the benefits of setting a max file size which will be filled in a circular fashion. http://www.sysinternals.com hth. Pd Yechiel Adar [EMAIL PROTECTED] wrote: I do not see the problem.SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB whichis the upper limit on NT, unless you used special startup parameter.Yechiel AdarMehish- 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 propermemory size for windows server running oracle. And today I logon to one of my small oracle on NT and found somethingI cannot understand. It is a small application running Oracle 817/win2k. SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from taskmanager, Oracle is using 1005M physical Memory and 1013M virtual memory(youcan 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 AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?Free Pop-Up Blocker - Get it now
RE: How windows manage memory: oracle
Title: Message winternalssoftware runs a website called sysinternals which has a bunch of useful free utilities for windows (and IIRC Linux now as well). pslist is one of those utilities. www.sysinternals.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yechiel AdarSent: 05 December 2003 07:24To: Multiple recipients of list ORACLE-LSubject: Re: How windows manage memory: oracle Thanks Paul. I did a check this week with out Win2000 tech support and was told that it come with 3GB process size while WNT was limited to 2GB (without special parameters). What is this pslist command? Is it something from Unix? Yechiel AdarMehish - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Thursday, December 04, 2003 7:34 PM Subject: Re: How windows manage memory: oracle Hi. The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024. its between 1.7 and 1.8 GB. I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4. W2K3 Server (not Advanced) ships with large memory support. In Windows 2000, one needed to acquire Advanced Server edition for large memory support. ways that you know that you hit the process memory limit: 1. unable to startup instance 2. unable to spawn a dedicated server process (in listener.log) 3. unable to allocate n bytes of memory in the shared pool (in the user's error message) For tracking memory usage by a process (namely, oracle.exe), I'd recommend using the sysinternals pslist utility, and log that to an OS file. There is the performance logs option in the OS, which gives you the benefits of setting a max file size which will be filled in a circular fashion. http://www.sysinternals.com hth. Pd Yechiel Adar [EMAIL PROTECTED] wrote: I do not see the problem.SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB whichis the upper limit on NT, unless you used special startup parameter.Yechiel AdarMehish- 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 propermemory size for windows server running oracle. And today I logon to one of my small oracle on NT and found somethingI cannot understand. It is a small application running Oracle 817/win2k. SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from taskmanager, Oracle is using 1005M physical Memory and 1013M virtual memory(youcan 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 AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a
Re: How windows manage memory: oracle
My favorite SF computer is Holly, from the Red Dwarf. Add a hologram like Rimmer and who needs anything else? I believe that Holly was running MS-Windows. On 12/04/2003 04:44:26 PM, Bellow, Bambi wrote: I know I've posted this before, but it's been many years, so here we go again. NT was supposed to be Windows' answer to VMS. WNT, doesn't stand for anything, so how did they come up with the name? V+1=W M+1=N S+1=T Just like I-1=H B-1=A M-1=L Coincidence? Bambi. -Original Message- Sent: Thursday, December 04, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Even though I have never touched VMS myself, I completely agree that it is (was) a great operating system, I've just heard so many good words from respectable sources about it :) About Windows, probably the initial idea was great but since MS is a marketing driven company, they just left off most of the good pieces in order to release new versions sooner... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:19 PM 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: [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). 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: [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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
Re: How windows manage memory: oracle
Hi, But PGA is only 40M(This is the sum of all process's v$sesstat). So there is more memory utilization then oracle actually should use. From task manager, it is 2018(Physical+Virtual), But from oracle v$(sga + pga) it is only 1020M.This is the problem. Zhu Chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 9:59 PM I do not see the problem. SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB which is the upper limit on NT, unless you used special startup parameter. 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 Size75804 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). -- 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).
Re: How windows manage memory: oracle
Hi. The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024. its between 1.7 and 1.8 GB. I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4. W2K3 Server (not Advanced) ships with large memory support. In Windows 2000, one needed to acquire Advanced Server edition for large memory support. ways that you know that you hit the process memory limit: 1. unable to startup instance 2. unable to spawn a dedicated server process (in listener.log) 3. unable to allocate n bytes of memory in the shared pool (in the user's error message) For tracking memory usage by a process (namely, oracle.exe), I'd recommend using the sysinternals pslist utility, and log that to an OS file. There is the performance logs option in the OS, which gives you the benefits of setting a max file size which will be filled in a circular fashion. http://www.sysinternals.com hth. Pd Yechiel Adar [EMAIL PROTECTED] wrote: I do not see the problem.SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB whichis the upper limit on NT, unless you used special startup parameter.Yechiel AdarMehish- 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 propermemory size for windows server running oracle. And today I logon to one of my small oracle on NT and found somethingI cannot understand. It is a small application running Oracle 817/win2k. SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from taskmanager, Oracle is using 1005M physical Memory and 1013M virtual memory(youcan 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 AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Free Pop-Up Blocker - Get it now
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: [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: 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: [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). 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: [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: How windows manage memory: oracle
Even though I have never touched VMS myself, I completely agree that it is (was) a great operating system, I've just heard so many good words from respectable sources about it :) About Windows, probably the initial idea was great but since MS is a marketing driven company, they just left off most of the good pieces in order to release new versions sooner... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:19 PM 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: [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). 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: [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: Tanel Poder 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: How windows manage memory: oracle
I know I've posted this before, but it's been many years, so here we go again. NT was supposed to be Windows' answer to VMS. WNT, doesn't stand for anything, so how did they come up with the name? V+1=W M+1=N S+1=T Just like I-1=H B-1=A M-1=L Coincidence? Bambi. -Original Message- Sent: Thursday, December 04, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Even though I have never touched VMS myself, I completely agree that it is (was) a great operating system, I've just heard so many good words from respectable sources about it :) About Windows, probably the initial idea was great but since MS is a marketing driven company, they just left off most of the good pieces in order to release new versions sooner... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:19 PM 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: [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). 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: [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: Tanel Poder 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
