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

AIX 5.2 is rock solid 64-bit OS. The maximum SGA size that I've seen on P 960 was 6GB, without any problems. Block size was 32K. Of course there weren't many benefits, either. If you want to have high buffer cache hit ratio, my advice is to get Connor McDonald's script. It's free, as opposed to gigabytes of RAM. Do you have free buffer waits? If so, may be you should write faster, for example, by activating async_IO kernel extension. If you said that you needed enormous shared pool or Java pool, I'd understand, but buffer cache perplexes me a bit. Unrelated to that, Pete, when are we going to get .NOT pool? 10g now has two processes that are monitoring and controlling memory usage (MMAN & MMON), so it would be possible to allocate few hundred megs for .NOT data providers?

--

Mladen Gogala
Ext. 121

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

From: Sonja Šehovic [mailto:sonja.sehovic_at_pbz.hr] Sent: Thursday, December 02, 2004 10: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 - 10:18:48 CST