Re: oracle-l Digest V6 #242

From: Taral Desai <taral.desai_at_gmail.com>
Date: Mon, 17 Aug 2009 08:47:25 -0500
Message-ID: <2b0cd5cd0908170647g61cbc89fib9c567579a803459_at_mail.gmail.com>

Well, both parameters are different and have different usage.

db_writer_processes will let you know how much db writer process are used for your I/O.

filesystemio_options let you know you want to use async I/O or serial. If it's et for async and that is not supported by OS then oracle will probably make serial or initiate small process for I/O to simulate async effect.

On Sun, Aug 16, 2009 at 12:08 AM, FreeLists Mailing List Manager < ecartis_at_freelists.org> wrote:

> oracle-l Digest Sat, 15 Aug 2009 Volume: 06 Issue: 242
>
> In This Issue:
> db_writer_processes and Async IO ???
>
> ----------------------------------------------------------------------
>
> Date: Sat, 15 Aug 2009 15:36:28 -0700 (PDT)
> From: dba1 mcc <mccdba1_at_yahoo.com>
> Subject: db_writer_processes and Async IO ???
>
> 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?
>
> Thanks.
>
>
>
>
> ------------------------------
>
> End of oracle-l Digest V6 #242
> ******************************
>
>

-- 

Thanks & Regards,
Taral Desai
Marie von Ebner-Eschenbach<http://www.brainyquote.com/quotes/authors/m/marie_von_ebnereschenbac.html>
- "Even a stopped clock is right twice a day."

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

Received on Mon Aug 17 2009 - 08:47:25 CDT