Re: What are DBWR timeouts?

Vipin Gokhale (vgokhale_at_us.oracle.com) wrote:

: In article <3m3iuv$ghk_at_mrnews.mro.dec.com>, babineau_at_eps.enet.dec.com () writes:
: >
: >What are DBWR timeouts?
: >--
: >Nancy Babineau
: >Applications Systems Engineering Performance | Opinions are mine,
: >Digital Equipment Corporation | not those of my
: >Merrimack, NH | employer.
: >nancy.babineau._at_mko.mts.dec.com |
: >
: >
: >Hi all,
: >what causes "DBWR timeouts" ??
: >
: > I see a large number of them, around 8K. What can I do about it?
: > I have looked quite a bit in the doc set including the tuning guide.
: > (boy I wish that thing had an index).
: >
: > I would appreciate your ideas!!! -Nancy
: >
: >
: >
 

: Once again, don't worry about it - dbwr in your case is just looking for
: work.
 

: --
: =====================================================================
: Vipin Gokhale
: DEC SBU
: Oracle Corporation
: Disclaimer: Any opinions expressed here are mine and not that
: of my employer.
: =====================================================================

dbwr timeouts occur normally in all Oracle databases as Vipin comments above. Your dbwr will timeout every three seconds with no other prompting by other kinds of activity, such as shadows scanning the SGA or checkpoints. When the dbwr times out, it scans the dirty list for blocks to write to disk.

You can ignore dbwr timeouts of any kind, they are only meaningful when compared to other stats such as dbwr free needed, dbwr low, which can some idea of how your dbwr activity is being driven, i.e. either by transactions occuring or by being idle. Received on Mon Apr 24 1995 - 00:00:00 CEST