Re: Using Direct I/O Filesystem for Oracle Database
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: juniordba2004@xxxxxxxxx
- Date: Thu, 10 Jan 2008 06:10:01 +0700
BismillahirRehmanirRahim,
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??
regards
ujang
On 1/9/08, Junior DBA <juniordba2004@xxxxxxxxx> wrote:
> 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 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
