Database Administration (MOSC)

MOSC Banner

Session memory per user

edited Aug 6, 2013 6:10AM in Database Administration (MOSC) 10 commentsAnswered
I am building a query to retrieve average session memory per user. So far I cam up with the following:

SELECT s1.username, AVG(s2.value) "avg session memory"
FROM v$session s1
JOIN v$sesstat s2 USING(SID)
JOIN v$statname s3 USING(STATISTIC#)
WHERE s1.TYPE='USER' AND s3.NAME IN('session pga memory','session uga memory') AND s1.username IS NOT NULL
GROUP BY s1.username;

And I just wanted to make sure I am correct and I would appreciate any feedback

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center