Re: SGA size

  • From: "Helen Mitchell" <HelenJMitchell@xxxxxxxxxxx>
  • To: <JApplewhite@xxxxxxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 2 Sep 2006 09:46:53 -0600

Do you have a "rule of thumb" for how much of the RAM you use for the SGA?
  ----- Original Message ----- 
  From: JApplewhite@xxxxxxxxxxxxx 
  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@xxxxxxxxx> 
        Sent by: oracle-l-bounce@xxxxxxxxxxxxx 
        09/01/2006 05:45 PM Please respond to

       To "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>  
              Subject SGA size 



      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? 
  Satheesh Babu.S 

Other related posts: