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