Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Free Memory in relation to SGA
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