Pavan DBA's Blog

The DBA Knowledge Store

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


WHERE spid = 2587;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: