Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: disk_asynch_io  and db_writer_processes on RAW DBFs

Joseph Amalraj

2006-02-20

Replies:

Hi,
 
A related question. Will ODM on raw devices, give better performance than just raw devices - because it  shares file descriptor tables ?
 
Thanks
 
Joseph Amalraj

Steve Adams <steve.adams@ixora.com.au> wrote:
Hi Deepak,

I suggest that you allow all these parameters to take their default
values at first. If you encounter any write I/O related waits once your
migration to ODM is complete, then they can be tuned in retrospect.

Instead, you should consider whether read I/O performance might suffer
because of a net reduction in memory available for caching.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all


Deepak Sharma wrote:
> OS: Sun Solaris 2.8
> Database: Oracle 10.1.0.4
> CPU_COUNT: 32
>
> On a database using RAW datafiles, what values
> should be specified for "db_writer_processes"
> and/or "filesystemio_options", assuming that
> "disk_asynch_io=TRUE" (also async i/o is available at
> OS-level) ?
--
http://www.freelists.org/webpage/oracle-l



©2008 dba.5341.com - Jax Systems, LLC, U.S.A.