Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: V$SGASTAT in 10.2 and the Reserved Pool

RE: V$SGASTAT in 10.2 and the Reserved Pool

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Mon, 25 Jun 2007 01:12:13 +0800
Message-id: <018501c7b682$cef70f50$6701a8c0@windows01>


Reseved shared pool memory is physically a part of normal shared pool memory. Oracle spreads the reserved pool evenly across all shared pool memory extents, that way the reserved pool can grow-shrink easier along with rest of shared pool.  

When you do a shared pool heapdump, you'd see there are tiny chunks of memory called "reserved stoppers". When kgh heap manager is searching for free space within an extent and hits the reserved stopper chunk, it will know that memory from this stopper up to end of extent is reserved, thus doesn't allow small allocations there.  

Tanel.  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roby Sherman
Sent: Sunday, June 24, 2007 23:50
To: oracle-l
Subject: Re: V$SGASTAT in 10.2 and the Reserved Pool

Hi.

I got the principles, thanks, I was more curious of where it was tallied... It looks like reserved pool free memory is summed with general shared pool memory in V$SGASTAT... Slightly misleading, but I can deal with that. Thanks.  

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jun 24 2007 - 12:12:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US