Re: [Q] Increase SGA, increase performance ???

From: Anton Dischner <dischner_at_med.uni-muenchen.de>
Date: 1996/06/10
Message-ID: <dischner-1006961457390001_at_news.lrz-muenchen.de>#1/1


Hi there,

i did a SGA comparison with an interesting result:

Less SGA on a SGI was -faster- than a big SGA.

I am shure this is because file caching in my case was more effective than Oracle SGA-cache.

--> Try with small SGA sizes too !

Best regards,

Toni

-- 
A. Dischner, AIX sysadmin, Oracle DBA           | Maier's rule:
Institut fuer Klinische Chemie                  | Murphy is an
Klinikum Grosshadern                            | optimist.      
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 | 
Received on Mon Jun 10 1996 - 00:00:00 CEST

Original text of this message