Re: Using Direct I/O Filesystem for Oracle Database

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_at_yahoo.com> 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
--
http://www.freelists.org/webpage/oracle-l