Question: How can see the RAM used by a
Oracle PGA RAM is used by an Oracle session for sorting,
hash joins and storing SQL intermediate result sets.
This script will display the RAM for a specific session
RAM used in SQL execution plan step and
RAM used by session.
You can also see all RAM used by a specific user ID:
using (sid) join
'session pga memory' and