db_writer_processes and Async IO ???
From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Sat, 15 Aug 2009 15:36:28 -0700 (PDT)
Message-ID: <832306.17076.qm_at_web65716.mail.ac4.yahoo.com>
we have ORACLE 10Gr2 on Redhar AS LInux server version 4.X. I checked one of database init.ora have following setup:
Date: Sat, 15 Aug 2009 15:36:28 -0700 (PDT)
Message-ID: <832306.17076.qm_at_web65716.mail.ac4.yahoo.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 15 2009 - 17:36:28 CDT