-
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%';
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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';
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|