Re: db_writer_processes and Async IO ???
- From: Jared Still <jkstill@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Mon, 17 Aug 2009 09:39:33 -0700
On Sat, Aug 15, 2009 at 3:36 PM, dba1 mcc <mccdba1@xxxxxxxxx> 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
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
