Script to find PGA memory allocation to BG processes
Posted by Pavan DBA on February 23, 2012
*********************************************
PGA Memory allocation to background process
*********************************************
SELECT spid, program,
pga_max_mem max,
pga_alloc_mem alloc,
pga_used_mem used,
pga_freeable_mem free
FROM V$PROCESS
WHERE spid = 2587;
Pavan DBA's Blog 
Leave a Reply