Re: db_writers experience ?

> sta_at_logibec.com writes:
>
>Does anyone have any experience with "db_writers" init parameter?
>The server will use many "dbwriter" vs single writer as default.
>Stephane Ah-ki
>

I've had problems with having multiple dbwriters under solaris 2.3. The database comes up ok, but if you try to do anything that updates the control file, like adding a file to a tablespace, or dropping a tablespace, the database writers seem to trip over themselves trying to update the control file.

I have set db_writers = 1 and async_write=true. I've been told that the async_write is equivalent to having multiple database writers.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285