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)"
<Bruce.Reardon_at_comalco.riotinto.com.au> 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: Bruce.Reardon_at_comalco.riotinto.com.au
>
> 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: 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).
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: ctrassens_at_yahoo.com
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: 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).
Received on Wed Mar 06 2002 - 05:03:22 CST
