Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> filesystemio_options oracle 9i hpux

filesystemio_options oracle 9i hpux

From: amonte <ax.mount_at_gmail.com>
Date: Tue, 23 May 2006 08:42:40 +0200
Message-ID: <85c1fb130605222342k486f8b7co32d17ff23180505b@mail.gmail.com>


Hi

I am handling a 700GB Apps 11.5.10 database running on HP-UX PARi(went live last week). The performance is quite poor, I noticed that filesystemio_options by default is asynch. AFAIK there are three options, asynch, direct and setall, should this set to none if AIO and directio arent used?

I guess it has to use asynch (even though AIO is not supported in HPUX if raw device is not used) since direct i/o is not enabled. I deduced this because in fstab thse options are not used

nodatainlog,mincache=direct,convosync=direct

My experience in hpux is limited, worked with Solaris most of times. Does anyone know if enabling these options in Veritas JFS will make lot of difference? After enabling that do I have to set filesystemio_options to directio?

Thanks

Alex

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 01:42:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US