Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: disk_asynch_io and db_writer_processes on RAW DBFs

Re: disk_asynch_io and db_writer_processes on RAW DBFs

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Mon, 20 Feb 2006 16:32:25 -0800 (PST)
Message-ID: <20060221003225.43923.qmail@web413.biz.mail.mud.yahoo.com>


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_at_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


  


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 20 2006 - 18:32:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US