Re: db-writers and UNIX

You don't necessarily have to enable it in the init-file, eg. on AIX async is the default. So, check V$PARAMETER to see if it is enabled, if so, the db_writers will be started but won't have anything to do. And that's OK, as long as async-io has been enabled on OS-level. For AIX: check with  'lsdev -C -l aio0'.
--
Kind Regards,

Gerard

R. Steven Brown <rstevenbrown_at_earthlink.net> wrote in article <7hg85t$i2g$1_at_birch.prod.itd.earthlink.net>...
> 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 - 01:35:06 CDT