Re: Using Direct I/O Filesystem for Oracle Database
Date: Thu, 10 Jan 2008 06:10:01 +0700
Muhammad Salman Faheem,
you may try ORION for the stress testing purpose, if your db isn't
production yet -:(,
so after your database operation, you may compare it with the orion result, and take attention on the difference.
if you want to improve, why don't you try ASM??
On 1/9/08, Junior DBA <juniordba2004_at_yahoo.com> wrote:
> 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 &
> dbwr_io_slaves =0
> To improve Disk I/O Performance We re-mount Oracle Database FileSystems [
> containing Datafiles,logfiles & archive logs] with forcedirectio,noatime
> After remounting the Oracle Filesystems with forcedirectio,noatime i
> changed the filesystemio_options to setall i.e.
> (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 them fast with Yahoo! Search.
-- regards ujang "I believe that exchange rate volatility is a major threat to prosperity in the world today" Dr. Robert A. Mundell, Nobel Laureate 1999 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 09 2008 - 17:10:01 CST