Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SGA QUESTION

SGA QUESTION

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Sat, 23 Jun 2001 11:23:18 -0700
Message-ID: <F001.003357AD.20010623112022@fatcity.com>

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 Sat Jun 23 2001 - 13:23:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US