Re: disk_async_io vs. multiple db_writer_processes

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Sat, 4 Mar 2006 05:29:30 -0800 (PST)
Message-ID: <20060304132930.52260.qmail@web402.biz.mail.mud.yahoo.com>

You can also look at the option of using quick i/o or ODM.   I normally set both disk_async_io to TRUE and value of db_writer_processes > 1 after ensuring i/o is balanced using some type of logical/physical striping with proper configuration of I/O sizes.       

Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:   Following is an excellant place to start: http://www.ixora.com.au/notes/direct_io.htm

> Hello all:
> I would like to ask for your expert opinions on
> the topic of using disk_async_io, and the use of
> multiple db_writer_processes. We're running
> Oracle E-business suites 11.5.10(9i-9205-32bit)
> on Sun E6900, 12 CPUs, 48GB RAM, Solaris 9/64bit.
>
>
> By default, disk_async_io, filesystemio_options;
> db_writer_processes are default to TRUE, ASYNC,
> and 3. The database files(redologs, datafiles,
> controlfiles) are allocated on Sun 3510 storage
> arrays(Hardware RAID10). The UFS filesystems are
> mounted with forcedirectio option.
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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




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

Received on Sat Mar 04 2006 - 07:29:30 CST