pga size and pmap , heap

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 27 Jul 2005 06:02:03 -0700
Message-ID: <1122469323.316024.14660@g14g2000cwa.googlegroups.com>

Hi ,

As i read in documents , oracle pga is allocated inside the heap segment of process.

Than , when i run pmap 13933 and
select
p.spid,p.PGA_USED_MEM,p.PGA_ALLOC_MEM,p.PGA_FREEABLE_MEM,p.PGA_MAX_MEM from v$process p where spid=13933

query , i see very different results:

pmap output:

mapped: 1855456 KB writable/private: 23856 KB shared: 1657904 KB

sql output:
SPID PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM PGA_MAX_MEM 13933 592721 3380657 393216 137986177

According to the pmap output:

does the private memory contains the pga? if so why does the sizes differ ?

kind regards,
tolga Received on Wed Jul 27 2005 - 08:02:03 CDT