Re: SGA size

From: Helen Mitchell <HelenJMitchell_at_Comcast.net>
Date: Sat, 2 Sep 2006 09:46:53 -0600
Message-ID: <001f01c6cea7$035aa410$0407a8c0@RCS.COM>

Do you have a "rule of thumb" for how much of the RAM you use for the SGA?

Original Message ----- From: JApplewhite_at_austinisd.org To: 'Oracle-L Freelists' Sent: Friday, September 01, 2006 5:49 PM Subject: Re: SGA size

Sure, that's possible, though at the low end. I used to run a 7.3.2 database on an old laptop that had only 32MB total RAM and I think I ran it with a 4MB SGA. I didn't need a big Buffer Cache or Shared Pool. You could make it run pretty lean.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

I feel so unnecessary. -- Rufus Thomas

                ( "Do the Funky Chicken")



        "Satheesh Babu" <satheeshbabu.s_at_gmail.com> 
        Sent by: oracle-l-bounce_at_freelists.org 
        09/01/2006 05:45 PM Please respond to
              satheeshbabu.s_at_gmail.com 


       To "'Oracle-L Freelists'" <oracle-l_at_freelists.org>  
              cc  
              Subject SGA size 

              

       



  List, 
      We have a client running oracle 7.3.4 ( I know it is outdated we are pushing to 9i), the sga size is 5MB. That’s right it is 5MB. Can a instance run with 5mb of SGA? Or is the dictionary table giving me the wrong info or Am I missing something here?

Regards,
Satheesh Babu.S

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

Received on Sat Sep 02 2006 - 10:46:53 CDT