Re: db-writers and UNIX

Thanks much for the help everyone. Now I understand a little better about how the db write processes work. Seems the rule of thumb is 2x # disks. What about controllers. Let's say I have 2 controllers across 8 disks. Would I have 16 dbwr processes? Many of our configurations is several hundred GB spread across 9GB drives. Does 2X # disks still hold true?

Thanks,
stj

Scott wrote:

> Not the case here. ASYNCH_IO is false. We are not using RAW partitions.
>
> "R. Steven Brown" wrote:
>
> > Check to see if you have ASYNCH IO enabled in your init file. If you do, it
> > will not allow multiple db writers to start.
> >
> > R. Steven Brown
> > Oracle DBA, Best Consulting
> >
> > Scott <scott_at_scott.com> wrote in message news:373B2898.953BA47C_at_scott.com...
> > > We have a 7.3.3.5 Oracle instance that has db_writers=4. Upon startup,
> > > there is only 1 dbwr writer process.
> > > There are some processes called ora_db01_SID, ora_db02_SID, ora_db03_SID
> > > and ora_db04_SID also. Are
> > > these the db_writer processes. UNIX ps shows very little time on the
> > > dbxx process and much time on the
> > > DBWR process after a days uptime. Shouldn't multiple db_writers be
> > > called DBW0, DBW1, etc.? Any ideas
> > > why this would happen? Is it normal?
> > >
> > > stj
> > >
> > >
> > >
Received on Mon May 17 1999 - 07:37:23 CDT