RE: Free Memory in v$sgastat

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. 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 (Practical Oracle 8i) and read all about the architecture. I'll get rich from all commissions I receive.

of large pool.
On 12/16/2003 12:24:25 AM, Sinardy Xing wrote:
> 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 RDBMS can't make use of this space? everything are in terms of Oracle Block, you can release and reuse the blocks.
> Well maybe quite difficult to get long continuous blocks, but it still free space, I am so blur now....
>
>
> Sinardy
>
> -----Original Message-----
> Sent: 16 December 2003 12:54
> To: Multiple recipients of list ORACLE-L
>
>
> 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 things
> like session_uga_memory and session_pga_memory in v$mystat. In v9 there is also "session_stored_procedure_space".
> If the instance doesn't have enough room to load the next thing to execute (SQL, PL/SQL, Java), it will have
> to make room. Generally speaking, making room hurts. You want to have enough room to load your
> stuff into the shared pool and then some. 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 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: mgogala_at_adelphia.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sinardy Xing
> INET: SinardyXing_at_bkgcomsvc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Mladen Gogala
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sinardy Xing
  INET: SinardyXing_at_bkgcomsvc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).