As Windows does asynch IO by default, there is probably not too much
benefit in setting IO slaves.
On 8/21/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 21 2006 - 14:40:22 CDT
