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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbwr_io_slaves usage on sigle cpu microsoft windows

Re: dbwr_io_slaves usage on sigle cpu microsoft windows

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Mon, 21 Aug 2006 14:20:19 -0400
Message-ID: <cd4305c10608211120x3424690cl7ac9aaa6fbd64464@mail.gmail.com>


Thanks a lot Anjo for your answer, but I'm not enough lucid to understand your answer.
My problem resides in the fact db_writer_processes has as default 1 on my 10gr2 database,
and I don't feel enough confident to change this configuration.

select name,value from v$parameter where name in ('db_writer_processes','dbwr_io_slaves')

dbwr_io_slaves          0
db_writer_processes     1

I was reading in rman could be beneficial to set dbwr_io_slaves, I'm using a normal pc (one processor), no scsi or other special disk, using windows 2000, if you could extend your answer you'll be very helpful to me, I don't know too much about hardware, thanks again :).

On 8/21/06, Anjo Kolk <anjo.kolk_at_oraperf.com> wrote:
>
> If each slave does synchronous IOs, then it is really good to do. If the
> IOs are done asynchronously, the benefit is not as big.
>
>
> On 8/21/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> >
> > Hi please
> > Is advisable to set dbwr_io_slaves to a value higher than 0 in a single
> > cpu (normal pc having one hard disk) on microsoft windows 2000 xp or 2003,
> > 10gr2.
> > Some experience on using it,
> > I had read it's advisable, if it is supported by the platform but I'll
> > like if some one could please share his expeience about it.
> >
> > Thank you :)
> >
> >
> >
> > --
> > ----------------------------------------
> > http://www.oracleboliviaspecialists.com/
> >
> > Oracle Certified Profesional 9i 10g
> > Orace Certified Professional Developer 6i
> >
> > 10 years of experience from Oracle 7 to Oracle10g and developer 6i
> >
>
>
>
> --
> Anjo Kolk
> Owner and Founder OraPerf Projects
> tel: +31-577-712000
> mob: +31-6-55340888
>

-- 
----------------------------------------
http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 21 2006 - 13:20:19 CDT

Original text of this message

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