Re: How windows manage memory: oracle

What about session UGA memory?

Do where name like 'session %ga%');

Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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: chao_ping_at_vip.163.com
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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).