Re: SGA QUESTION

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Tue, 26 Jun 2001 00:19:45 -0700
Message-ID: <F001.00337A72.20010625231524@fatcity.com>

My database will be growing 20 GB per
year.
Anyway . Forget it .
Thank you All.
Bunyamin
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Christopher Spence To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 6:32 PM Subject: RE: SGA QUESTION

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

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

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

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

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

  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 Tue Jun 26 2001 - 02:19:45 CDT