Re: AIX 4.2 and Oracle 7.2/7.3 SGA/PGA and virtual memory

Hi,

i did performance measurements with different SGA sizes on different CPUs.

IBM RS6000 5xx and SMP, SGI, HP. Oracle 7.x

I found that a small SGA performs better than a big SGA !! I believe this is because filesystem caching performs better than Oracle SGA-caching.

Give a small SGA a try!
Make Oracle-blocksize as big as possible.

Kind regards,

Toni

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |