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

Well, we have buffer waits and also async I/O activated. Can you tell me where I can get the script you mentioned?

TIA,
Sonja

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

From: Gogala, Mladen [mailto:MGogala_at_allegientsystems.com] Sent: Thursday, December 02, 2004 5:17 PM To: oracle-l_at_freelists.org
Subject: 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 =A9ehovic [mailto:sonja.sehovic_at_pbz.hr]=20 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.=3D20
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
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 03 2004 - 02:35:11 CST