RE: Using Direct I/O Filesystem for Oracle Database

Muhammad Salman Faheem,  

You should read, if you have not already, Steve Adam's works in ixora
(http://www.ixora.com.au <http://www.ixora.com.au/> ) for async io and
direct io and Oracle internals, and also Cary Millsap's works in hotsos
(www.hotsos.com) that deals with the proportionality of the effect on change
As Dave said have benchmarks and baselines that allow you to establish and measure change.  

-Krish  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Junior DBA
Sent: Tuesday, January 08, 2008 10:41 PM To: oracle-l_at_freelists.org
Subject: Using Direct I/O Filesystem for Oracle Database  

BismillahirRehmanirRahim  

Hi All,  

We are running Oracle 10g R1 on Sun SPARC Solaris 9 Sun Fire V890 Server.  

By default we have following setting in the Database:  

disk_asynch_io = TRUE

filesystemio_options= asynch &

db_writer_processes=1

dbwr_io_slaves =0  

To improve Disk I/O Performance We re-mount Oracle Database FileSystems [ containing Datafiles,logfiles & archive logs] with forcedirectio,noatime option.  

After remounting the Oracle Filesystems with forcedirectio,noatime i changed the filesystemio_options to setall i.e.  

filesystemio_options=setall  

(1) I need to know if i missed something or made any mistake.
 

(2) Do i need to change dbwr_io_slaves or db_writer_processes values
 

(3) What else i could do to improve DISK I/O performance
 

Appreciate your valuable feedback.  

Best Regards,  

Your DBA Colleague

Muhammad Salman Faheem     

Looking for last minute shopping deals? Find <http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/ca tegory.php?category=shopping> them fast with Yahoo! Search.

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