Question: I know how to display the total
PGA RAM for a user but I di not know the data dictionary query for
displaying the RAM used by a specific user. Is there a script
t display the RAM usage for a user?
Answer: The Oracle PGA RAM is used
by a user primarily for sorting, hash joins and storing SQL
intermediate result sets. Yes, this script will display the RAM for a
specific user ID:
select
username,
name,
value
from
v$session
join
v$sesstat using (sid)
join
v$statname using
(statistic#)
where
name = 'session pga memory'
and
username='MYUSER';
Also see
RAM used in SQL execution plan step and
RAM used by session.
