RE: buffer cache > 2GB and sga_max_size

From: Stevens, Ed <ED.STEVENS_at_NMM.NISSAN-USA.COM>
Date: Thu, 2 Dec 2004 09:45:31 -0600
Message-ID: <D95631492847D511A32E00B0D0D02E8E08B5F7DF@nmmset01.nmm.nna>

Given that you don't want the total of all of your SGAs to be more than 1/3 to 1/2 of your physical memory (various people give various percentages, but the principle is the same), you must have a pretty big machine there, else you'll end up thrashing yourself to death on OS page swaps. Ed Stevens

-----Original Message-----

From: Sonja ©ehovic [mailto:sonja.sehovic_at_pbz.hr] Sent: Thursday, December 02, 2004 9:36 AM To: oracle-l_at_freelists.org
Subject: buffer cache > 2GB and sga_max_size > 4GB possible problems?

Hi!

Oracle 9.2.0.4 on AIX 5.2.
I'm thinking of resizing my buffer cache >2GB and max_sga_size > 4GB.=20 Did anyone saw any bugs or problems related to this issue?

TIA,
Sonja
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 02 2004 - 09:46:57 CST

RE: buffer cache > 2GB and sga_max_size > 4GB possible problems?