Re: Free Memory in v$sgastat

2003-12-16 Thread Mladen Gogala
Sinardy, where does oracle say anything like that about free memory? Please, quote me an article or URL. Second, if you are not using MTS, your PGA is a part of your dedicated server address space, not SGA. It does exist, though. Similarly, UGA goes to shared pool instead. Buy yourself The Book

RE: Free Memory in v$sgastat

2003-12-16 Thread Sinardy Xing
Hi, Those are lines from my friend Oracle University student guide (Original) Sinardy -Original Message- Sent: 16 December 2003 22:34 To: Multiple recipients of list ORACLE-L Sinardy, where does oracle say anything like that about free memory? Please, quote me an article or URL.

Re: Free Memory in v$sgastat

2003-12-15 Thread Mladen Gogala
Sinardy, you've attended wrong database tuning course. You need free memory in your shared pool. There is no such thing as sga fragmentation unless there is not enough free memory to satisfy average request. While oracle is not monitoring the size of an average shared pool request. you have

RE: Free Memory in v$sgastat

2003-12-15 Thread Sinardy Xing
Hi Mladen, I try to understand 8i, and I am not using MTS, my current understanding is UGA and PGA only exists (I mean in use or in the picture) when you are using MTS. Oracle themselves said 'free memory' are more properly thought of as wasted space I just wondering why this million dollar