Threads in Oracle on NT generally consume 1mb each one. Therefore, Oracle provides an utility named as ORASTACK <executable name> <new stack size> to change this behavior.
Regards. --- "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> wrote: > 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). ===== Ing. Christian Trassens Senior DBA & Unix Administrator Phone: 0034-699240979 0034-649824704 __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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).
