RE: buffer cache > 2GB and sga_max_size > 4GB possible problems?
- From: "Stevens, Ed" <ED.STEVENS@xxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Dec 2004 09:45:31 -0600
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@xxxxxx]
Sent: Thursday, December 02, 2004 9:36 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
