Re: disk_asynch_io and db_writer_processes on RAW DBFs

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