Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Nb dbwr

Re: Nb dbwr

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Feb 2007 15:35:16 -0800
Message-ID: <1171409712.912971.161310@v33g2000cwv.googlegroups.com>


On Feb 13, 6:08 pm, DA Morgan <damor..._at_psoug.org> wrote:
> astalavista wrote:
> > hi,
>
> > Any advices or link about the number
> > of db writer processes ...
> > Oracle 9.2.0.6
>
> > Thanks in advance
>
> Absolutely. Gather metrics and don't alter anything without a
> solid reason to do so based on your hardware, your application,
> and your usage.
>
> Now with respect to 9.2.0.6, on the other hand, you might want
> to just patch it up to something current before desupport
> starts in June.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

What OS? What kind of file system is in use? How many cpu's? The default is greater of 1 or #cpu / 8 number of database writers. The answer depends on several factors including if you have significant waits for certain latches. See the Performance and Tuning manual.

HTH -- Mark D Powell -- Received on Tue Feb 13 2007 - 17:35:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US