Re: db_writer_processes and Async IO ???

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 17 Aug 2009 09:39:33 -0700
Message-ID: <bf46380908170939t7b2f0a33y913a119f9b030eed_at_mail.gmail.com>

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

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 17 2009 - 11:39:33 CDT