per session memory usage

[khussain]

If a user connects to Oracle, and is not doing anything, how much memory will that idle session take up (just for being connected)?

[sambavan]

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%';


Sam

[khussain]

Thanks Sam.

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';

[khussain]

I thought I had it all clear, but I am not sure about the diff. between PGA and UGA (in a Dedicated Server environment) ?

in v$sessstat:
session pga memory
AND
session uga memory

[Edited by khussain on 09-04-2001 at 09:29 AM]