Re: Free Memory in v$sgastat

2003-12-16 Thread Mladen Gogala
. That room is also known as free space. Look into the tuning manual on the OTN and make sure that your buffer cache hit ratio is high enough (sorry folks, I couldn't resist). On 2003.12.15 23:19, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom

RE: Free Memory in v$sgastat

2003-12-16 Thread Sinardy Xing
cache hit ratio is high enough (sorry folks, I couldn't resist). On 2003.12.15 23:19, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks

Free Memory in v$sgastat

2003-12-15 Thread Sinardy Xing
Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these "free memory" aremore properly thought of as wasted space? Thanks Sinardy

Re: Free Memory in v$sgastat

2003-12-15 Thread Mladen Gogala
, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks Sinardy -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET

RE: Free Memory in v$sgastat

2003-12-15 Thread Sinardy Xing
, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks Sinardy -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net