RE: Using Direct I/O Filesystem for Oracle Database
- From: <krish.hariharan@xxxxxxxxxxxx>
- To: <juniordba2004@xxxxxxxxx>
- Date: Wed, 9 Jan 2008 11:13:56 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Junior DBA
Sent: Tuesday, January 08, 2008 10:41 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
