Re: db_writer_processes and Async IO ???
Date: Mon, 17 Aug 2009 09:39:33 -0700
On Sat, Aug 15, 2009 at 3:36 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> we have ORACLE 10Gr2 on Redhar AS LInux server version 4.X. I checked one
> of database init.ora have following setup:
> db_writer_processes = 2
> filesystemio_options = asynch
> DISK_ASYNCH_IO = true
> TAPE_ASYNCH_IO = true
> Based on what I know "db_writer_processes " and "filesystemio_options =
> asynch" are exclusive. Can anyone tell me database will use whiche one?
This should help answer your question:
ps -flu<oracle_owner> | grep dbw.*$ORACLE_SID
Certifiable Oracle DBA and Part Time Perl Evangelist