Re: Free Memory in v$sgastat
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
Re: Free Memory in v$sgastat
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Free Memory in v$sgastat
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).