Glenn Fawcett's Weblog

Ensuring directIO with Oracle 10.2.0.3 on Solaris UFS filesystems

Thursday Feb 14, 2008

I usually really dislike blog entries that have nothing to say other than repackage bug descriptions and offer them up as knowledge, but in this case I have made an exception since the full impact of the bug is not fully described.

There is a fairly nasty Oracle bug with 10.2.0.3 that prevents the use of DirectIO with Solaris. The metalink note "406472.1" describes the failure modes but fails to mention the performance impact if you use "filesystemio_options=setall" and fail to have the mandatory patch "5752399" in place.

This was particularly troubling to me since we have been recommending for years the use of the "setall" to ensure all the proper filesystem options are set for optimal performance. I just finished working a customer situation where this patch was not installed and their critical batch run-times were nearly 4x as large... Not a pretty situation.... OK, So bottom line:

    MAKE SURE YOU INSTALL "5752399" WHEN USING ORACLE 10.2.0.3 !!!

[2] Comments
Like this post? del.icio.us | furl | slashdot | technorati | digg
Posted at 10:57AM Feb 14, 2008 by glennf in Oracle
Tags:
Comments:

I believe this is only relevant for 10.2.0.3 on SPARC, not X64.

Posted by 65.203.234.66 on April 03, 2008 at 03:29 PM PDT #

We use zfs on a small percentage of our system delivered by a sub-contractor and internal we install on the StorNext cvfs file system. Any information on whether this issue has been seen on this file systems.

Posted by Jeff on May 10, 2008 at 03:36 PM PDT #

Post a Comment:
Comments are closed for this entry.