Sean, I'm also interested in this and whilst I can't provide a definitive answer I can provide some numbers and a script that I'm using - if anyone can point out problems or issues with the script I'll learn and correct them.
Anyway, script is below (originally written to try to help find a memory leak). When I run this on our Production instance (all dedicated connections), the values it returns are: pga_curr 119.1 pga_max 119.2 uga_curr 12.5 uga_max 76.8 sum of v$sga = 386.2 Sum v$sga + pga curr + uga_curr = 517.8Mb Using Task Manager on the server shows oracle.exe memory usage at 549980 = 537.1 Mb and VM usage = 566936 = 553.6 Mb I can't explain the difference between the Task Manager output and the script output - maybe memory structures not in v$sga but I wouldn't have thought they added to 20 Mb. Our v$session count was 26 which was the number of pga rows returned by the script (& yes it includes the background processes). -- @pga_usage.sql -- 24-Dec-2001 , Bruce Reardon -- 6-Mar-2002 , B Reardon - added uga_current values. COLUMN pga_curr format 99,999,999.9 COLUMN pga_max format 99,999,999.9 COLUMN uga_curr format 99,999,999.9 COLUMN uga_max format 99,999,999.9 COLUMN name FORMAT A25 COLUMN program FORMAT A30 BREAK ON report COMPUTE SUM LABEL "Total mem" OF pga_curr , pga_max , uga_curr , uga_max ON report select s.sid , s.username , s.program , pga_curr.value AS pga_curr, pga_max.value AS pga_max , uga_curr.value AS uga_curr , uga_max.value AS uga_max FROM v$session s , ( select st.sid , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session pga memory' ) pga_curr , ( select st.sid , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session pga memory max' ) pga_max , ( select st.sid , name , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session uga memory' ) uga_curr , ( select st.sid , name , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session uga memory max' ) uga_max WHERE pga_curr.sid = s.sid AND pga_max.sid = s.sid AND uga_curr.sid = s.sid AND uga_max.sid = s.sid ORDER BY pga_max , sid ; COLUMN value FORMAT 999.99 COMPUTE SUM LABEL "Total mem" OF value ON report select name , value /1024/1024 AS value from v$sga; HTH & hoping to learn more myself, Bruce Reardon -----Original Message----- Sent: Wednesday, 6 March 2002 3:31 I'm trying to get a handle on the amount of memory allocated to a dedicated server process using NT. From having examined manuals to to begin with the terminology seems to be inconsistent. There appear to be interchangeable references to PGA and UGA and also to Dedicated Server Process memory and Shadow Process Memory. Are these pairs one in the same?. Anyway apart from my personal confusion re previous I'd like to find out what memory is allocated on a server confgured to use dedicated server process. From Appendix B in the 8i Rel 2 Win NT Admin manual I though it would be 335K. However I have "heard" that in reality this is actually 2Mb. Can anyone give me the fact's please and reference sources for same too pleez!. ------------------------- Se�n O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
