Hi Paul, Thanks for the tip on sysinternals--great stuff!
PB --- Paul Drake <[EMAIL PROTECTED]> wrote: > 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 > 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" > 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). > > --------------------------------- > Do you Yahoo!? > Free Pop-Up Blocker - Get it now __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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).
