Thanks for your script. The whole site is an excellent resource. Thanks Tim,
I have run your script and also run a query against statistic 15 and 20 from v$sessstat (max UGA and PGA memory used ) SQL> SQL> select name,statistic#,sum(value/1024/1024) "Curr Mb" 2 from v$sesstat a, v$database c 3 where statistic# in (16,21) 4 group by name,statistic# 5 / NAME STATISTIC# Curr Mb --------- ---------- ---------- SID 16 2.8621788 SID 21 23.4703255 Running the oramem.sh script I return the following Total RAM = 16384Mb, Swap = 19779.85Mb used, 2686.51Mb free Total memory consumption by Oracle instance "SID": # Procs # Procs Max Sum Foregrnd Backgrnd Shm Kb Priv Kb Total Kb ======== ======== ====== ======= ======== 27 16 424600 106144 530744 So oracle shows 26Mb used where using a pmap command returns about 105Mb. I think I am comparing like with like here but obviously the results don't show that Does anybody have any other insight as to how what exactly the values in statistic# 16 & 21 can be used to indicate overall memory usage by Oracle processes Thanks John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
