VxFs filesystem and Oracle 8i database

[Lionel MAZE]

Which are the best mount vxfs options for a datafiles
filesystem ?

[Hai Nguyen_1]

One of the best options is largefiles.

Hai

[Jeff Schussele]

Hi Lionel,

A lot of this depends on what OS you're running & how the Oracle SGA will be configured.
So for argument let's say that you're running 11.0 & the Oracle SGA will be fairly large & will support buffering the writes.

Then you'd want
mincache=direct,convosync=direct
so that you're not "double-buffering" the writes.
Up-to-date patched 11.0 & new 11i systems will not suffer as high a performance hit from the added buffering, so you shouldn't have to avoid the OS buffer cache.

Rgds,
Jeff

[A. Clay Stephenson]

Depends upon the OS; under 11.0 rw,convosync=direct,mincache=direct,nodatainlog,delaylog

usually is best for datafiles and indices and especially if memory is limited. You reduce UNIX buffer cache and use the savings to increase the SGA.

However, under 11.11, nodatainlog,delaylog fore everything almost always works best combined with a fairly large UNIX buffer caches (800-1200MB).