If a user connects to Oracle, and is not doing anything, how much memory will that idle session take up (just for being connected)?
do the following query
select a.name b.value
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and a.name like '%ga%';
Life is a journey, not a destination!
I also found another one in Metalink that may be helpful to other:
SELECT username, trunc((value/1024)) || ' Kbytes' "Current session memory"
FROM v$session sess, v$sesstat stat, v$statname name
WHERE sess.sid = stat.sid
AND stat.statistic# = name.statistic#
AND name.name = 'session uga memory';
I thought I had it all clear, but I am not sure about the diff. between PGA and UGA (in a Dedicated Server environment) ?
session pga memory
session uga memory
[Edited by khussain on 09-04-2001 at 09:29 AM]
Click Here to Expand Forum to Full Width