Re: db_file_simultaneous_writes???

From Oracle documentation:

DB_FILE_SIMULTANEOUS_WRITES
Default value:
4
Range of values:
1 - 24
The number of simultaneous writes ("batches") for each database file when written by DBWR.

If the operating system supports only one write per device and cannot combine writes to adjacent blocks, then the value should be 1. Though the value has no maximum because DBWR writes blocks in groups, it is not useful to use a value larger than 24.

For more information, see Oracle7 Server Concepts.

See also your operating system-specific Oracle documentation for the default value.

xo55ox_at_hotmail.com wrote:
>
> Hi,
>
> I have been looking, but I did not find much information on this init.
> parameter, db_file_simultaneous_writes. I know that the value should be
> set between 4 to 25. But what's this parameter for? And what process
> does it affect/control?
>
> Thanks for the info.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Sep 17 1999 - 03:24:41 CDT