Re: latch waited dbwr

Valerie Groomes <70713.2270_at_CompuServe.COM> wrote:

>Has anyone had a problem with latch waits on the database writer?
>We're having a problem with the database writer becoming latch
>waited; it looks like it's waiting on datablocks. A number of the
>users also become latch waited and noone can work in the database.
>To correct the problem we have to shutdown abort the database and
>have to reboot the system because the dbwr process goes into a
>'zombie' state and can't be killed.

Are you using database writers or Async i/o to raw devices?

Also, what is your spin count set to. If it is default try reducing it to around 200. Received on Fri Mar 29 1996 - 00:00:00 CET