Query to get Memory Usage for Each User Session

Query to get Memory Usage for Each User Session:

SELECT a.username, b.value “Memory in bytes per session”
FROM v$session a, v$sesstat b, v$statname c
WHERE a.sid = b.sid

AND b.statistic# = c.statistic#
AND c.name = ‘session uga memory’;

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply