Ensuring directIO with Oracle 10.2.0.3 on Solaris UFS filesystems
By glennf on Feb 14, 2008
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 !!!