Proper FS mount options for Oracle filesystems

[Q4you]

For example, we use following line in /etc/fstab for mounting oracle data filesystem from XP storage in SAN envirnment using 2GB fiber channel cards, appx 16GB or meneory, HPUX 11i V1.

/dev/vg02/lvol1 /oradata01p vxfs delaylog,largefiles,nodatainlog,mincache=direct,convosync=direct 0 2

What are the recommended mount options for optimum IO performance ?
- oracle data
- Oracle index
- oracle redo
- oracle undo
- any application utilities
TIA,
Q

[Pedro Cirne]

Hi,

I think you've the right mount options for mounting Oracle data file systems.

You may check this very good link on hp-ux performance:

http://www8.itrc.hp.com/service/iv/node.do?source=search&node=prodITRC/WW_Start/N1|20|9|6|3

Another important point is the way you create lvols, have you made them Distributed?

Enjoy :)

Pedro

[Jean-Luc Oudart]

Hi

find attached revised version of same document (27 May 2003)

Regards
Jean-Luc

[Jean-Luc Oudart]

Hi again

you may want to read this document "A Quantitative Comparison between Raw Devices and File Systems for implementing Oracle Databases"

Regards
Jean-Luc

[Jean-Luc Oudart]

Also

you may check this prsentation "Best practices for Oracle on HPUX "

http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt

Regards
Jean-Luc