RE: SGA QUESTION

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Mon, 25 Jun 2001 07:53:31 -0700
Message-ID: <F001.003367F7.20010625073203@fatcity.com>

Who
knows.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>Perhaps your database is 100K perhaps it is 1000Pb.
<FONT face=Arial color=#0000ff

size=2>Perhaps it is DSS, DW, or even OLTP.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2> 
I
would say use a 8Gb sga and buy more memory, should be perfect for what your trying to do.
 
"Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Fuelspot

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Bunyamin K. Karadeniz   [mailto:bunyamink_at_havelsan.com.tr]Sent: Saturday, June 23, 2001   3:20 PMTo: Multiple recipients of list ORACLE-LSubject:   SGA QUESTION
  Hi GURUS,I HAVE A QUESTION.
   
  I will newly create a database and I have 8 GB   RAM.
   
  I will create my SGA as 1 GB .  IS it a   good Idea?
  I see that there is a variable size for the   SGA , How can I arrange that?
  How much must be log buffers for a 1GB   SGA?
  Thanks .
  BUNYAMIN
   
  STARTUP
  ORACLE instance started.Total System Global

  Area                         

  51168524 bytesFixed

  Size                                          

  70924 bytesVariable

  Size                                    

  34242560 bytesDatabase

  Buffers                                 

  16777216 bytesRedo

  Buffers                                        

  77824 bytes Received on Mon Jun 25 2001 - 09:53:31 CDT