Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: AIX 4.2 and Oracle 7.2/7.3 SGA/PGA and virtual memory
In article <dischner-ya02408000R0603971023310001_at_news.lrz-muenchen.de>,
Anton Dischner <dischner_at_med.uni-muenchen.de> wrote:
>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,
Interesting results but could we get some details like
Size of the DB
Size of the machines
Where the increase in SGA size caused performance to degrade
and What the machines were doing when performance started to degrade.
tia
Mark Rosenbaum Otey-Rosenbaum & Frazier, Inc. mjr_at_netcom.com Consultants in High Performance and (303) 727-7956 Scalable Computing and Applications POB 1397 ftp://ftp.netcom.com/pub/mj/mjr/resume/Boulder CO 80306 Received on Thu Mar 06 1997 - 00:00:00 CST