Re: dbwr_io_slaves usage on sigle cpu microsoft windows

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: juancarlosreyesp@xxxxxxxxx
  • Date: Mon, 21 Aug 2006 12:40:22 -0700

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@xxxxxxxxx> 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@xxxxxxxxxxx> 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@xxxxxxxxx>
> 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

Other related posts: