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

Home -> Community -> Usenet -> c.d.o.server -> Free Memory in relation to SGA

Free Memory in relation to SGA

From: twerty <2desp_at_iname.com>
Date: Tue, 19 Mar 2002 17:48:10 +0800
Message-ID: <a7714b$j4hfi$1@ID-51406.news.dfncis.de>


Hi,

    When I do a select * from v$sgastat, I find that my free memory in the SGA amounts to 484MB. As my library cache ratio hit and dictionary cache ratio hit are not as high as I would like them to be (between 90-94%), I am planning to use this particular free memory in the SGA (484 MB). My question is, does Oracle actually use this free memory in the SGA for its work processes? Or can I safely say that it is not a problem assigning the remaining say, 400 or 484MB of free space to my Shared Pool Memory and the Buffer Cache (which isn't of a very high quality either).

Many Thanks in Advance for the answers. Received on Tue Mar 19 2002 - 03:48:10 CST

Original text of this message

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