Re: db_writers

Increasing the number of database writers will increase your memory consumption, but it should not be to large. Each writer is a slave to the master writer and thus should consume no more that 1.7Mb. If Async io is an option on your platform I would recommend it, because all multiple database writers mimics is async io.

Each session is responsable for reading, thus increasing the number of database writers will not help read performance. To increase read performance for full table scans or fast index scans consider parallel query.

Regards
David Russell

Ed Lufker wrote in message <6ifgcc$amq$1_at_sloth.swcp.com>...
>Hi All:
>
> Does adding db_writers increase memory consumption by much, and
>will it help a system that is very read intensive?
>
>Is anyone on a Sun Ultra Sparc platform, and do you have the oracle
>parameters for for async io set, how does it work.
>
>thanks
>eddie lufker
>
Received on Sat May 02 1998 - 16:05:35 CDT