Re: More info about _db_writer_max_writes

2003-10-07 Thread Hans de Git
Thaks, log buffer is 2M. I don't see a connection between the the log buffer and this hidden parameter. BTW: this database issues 1500 ios per second. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 06 Oct 2003 08:19:27 -0800 Hans: This parame

Re: More info about _db_writer_max_writes

2003-10-06 Thread K Gopalakrishnan
Hans: This parameter limits the max # of buffers can be pending for an AIO operation. Usually you never need to tune (!) this parameter as the default holds good for most platforms. BTW what is the size of the log buffer? You will never have more than 4k pending buffers unless you have a really h

More info about _db_writer_max_writes

2003-10-06 Thread Hans de Git
Hi All, The current value for my AIX 4.3.3 / 8.1.7.4 instance parameter _db_writer_max_writes is 4096. I've just raised my aio maxreqs to 16384. Would it be beneficial to increase _db_writer_max_writes? HTH, Hans de Git _ MSN Zoeke