Search notes:

oradebug dump pga_detail_get

oradebug dump pga_detail_get populates v$process_memory_detail which shows PGA related memory information.
First, the PID of the process whose memory needs to be analyzed must be found in a session: 
select
   prc.pid
from
   v$session ses join
   v$process prc on ses.paddr = prc.addr
where
   ses.sid = userenv('sid');
Then, a user with sysdba privileges must dump the PGA information: 
oradebug setmypid
oradebug dump pga_detail_get 61
link: Tanel Poder's smem_detail.sql script.

Index