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