From bunyamink@havelsan.com.tr Tue, 26 Jun 2001 00:19:45 -0700
From: "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr>
Date: Tue, 26 Jun 2001 00:19:45 -0700
Subject: Re: SGA QUESTION
Message-ID: <F001.00337A72.20010625231524@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@fatcity.com" 
  title=ORACLE-L@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@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