Search notes:

Oracle: V$PROCESS_MEMORY_DETAIL

v$process_memory_detail shows PGA related memory information. This view (table) must be populated with a snapshot in order to contain data.

Such a snapshot might be created with oradebug dump pga_detail_get.

select
   category,
   heap_name,
   name,
   bytes,
   allocation_count,
   heap_descriptor,
   parent_heap_descriptor
from
   v$process_memory_detail
where
   pid = 61 and
   serial# = 288
order by
   category,
   heap_name,
   name;

Oracle: V$PROCESS_MEMORY_DETAIL

See also