Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

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
--
http://www.freelists.org/webpage/oracle-l

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

Other related posts:

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




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.