fs read buffer tuning in 5.1?

From: Bob.Kelley@BRINKSINC.COM
Date: Wed Dec 17 2003 - 16:58:13 EST


Is anyone familiar with the (db_block_size * db_file_multiblock_read_count
=<64K) calculation used by Oracle92 to determine those two variable
settings?

>From what I can find, the OS read buffer is 64K in AIX51, but is this a
tunable parameter?? Aparently Oracle doesn't recommend the individual
settings for these two variables which are required by AIX to maximize IO
efficiency, and one of my dbas is asking if the read buffer can be changed
to 128K?

Bobby Kelley Jr.
972-877-5341



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:17:24 EDT