Script to find memory usage by BG processes
Posted by Pavan DBA on February 23, 2012
**************************************
Memory usage for backgroung processes
**************************************
SELECT p.program,
p.spid,
pm.category,
pm.allocated,
pm.used,
pm.max_allocated
FROM V$PROCESS p, V$PROCESS_MEMORY pm
WHERE p.pid = pm.pid
AND p.spid = 2587;
Pavan DBA's Blog 
Leave a Reply