Re: SGA QUESTION

[Bunyamin K. Karadeniz]

My database will be growing 20 GB per year. Anyway . Forget it . Thank you All. Bunyamin ----- Original Message ----- From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 6:32 PM Subject: RE: SGA QUESTION Who knows.   Perhaps your database is 100K perhaps it is 1000Pb. Perhaps it is DSS, DW, or even OLTP.     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 Oracle DBA Fuelspot -----Original Message----- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 23, 2001 3:20 PM To: Multiple recipients of list ORACLE-L Subject: 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 bytes Fixed Size                                          70924 bytes Variable Size                                    34242560 bytes Database Buffers                                 16777216 bytes Redo Buffers                                        77824 bytes