RE: SGA Free memory

From: <genegurevich_at_discoverfinancial.com>
Date: Wed, 8 Feb 2006 11:43:40 -0600
Message-ID: <OFB2D7F13C.102E965B-ON8625710F.00615505-8625710F.006150E4@discoverfinancial.com>

I am at 9204 and I was experiencing ora-4031. That's why I started watching the free memory.

thank you

Gene Gurevich

                                                                           
             "Hameed, Amir"                                                
             <Amir.Hameed_at_xero                                             
             x.com>                                                     To 
                                       <genegurevich_at_discoverfinancial.com 
             02/08/2006 11:38          >, <oracle-l_at_freelists.org>         
             AM                                                         cc 
                                                                           
                                                                   Subject 
                                       RE: SGA Free memory

This is normal behavior as chunks are flushed from and added to the shared pool, the memory fluctuates. As long as you are not seeing ORA-04031 error or contention on the shared pool latch is not too high, you are fine. What RDBMS version are you on?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discoverfinancial.com
Sent: Wednesday, February 08, 2006 12:28 PM To: oracle-l_at_freelists.org
Subject: Re: SGA Free memory

Hi all:

I am watching the usage of the SGA on my database via the following command:

select to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'), name, bytes/(1024*1024) from v$sgastat, dual
where pool like '%shared%' and name = 'free memory' order by bytes asc ;

I am running it every 10 seconds. Recently I saw the free memory going from
25M to 145M over the course
of 10 sec. I'm wondering what could have caused it. Would appreciate any suggestions

thank you

Gene Gurevich
Oracle Engineering
224-405-4079

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 08 2006 - 11:43:40 CST