----- Original Message -----
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.
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"
<[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 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
