I have to set the parameter db_file_simultaneously_writes. This parameter is influceing the DBWR internal write batch size. The write batch size is calculated from the smallest value of the following
1. (db_files * db_file_simultaneous_writes)/2 or
2. 1/4 of the db_block_buffers or
3. Platform specific value for the internal write batch size.
Now, I have no idea what is the platform specific DBWR write batch size for Sun Solaris 8 with oracle 7.3.4 (I know this is an odd combination.. what to do..! Application wants it!!) and oracle 8i? Anybody know this value?
I appreciate your help!
Technical Lead (Databases)
Thomson Reuters (Markets)