Error Message

 

The ioctl can be observed with truss:

21770/1:        17.5346  0.0059 ioctl(259, (('V'<<24)|('X'<<16)|('F'<<8)|1), 0x00000004) = 0

 Apply Oracle patch# 10336129  to RDBMS 11.2.0.2  

 

Applies To

 This problem only impacts regular buffered IO on VXFS.

VXFS filesystems using ODM or mount option "mincache=direct" is not impacted.

RAC Clustered filesystems are not impacted because ODM is a requirement.  

Poor Oracle IO performance on VXFS for RDBMS 11gR2 compared to 10gR2 on Solaris This problem is introduced in RDBMS 11.2.0.1 on SolarisRegardless of what you Oracle "filesystemio_options = asynch | none" is set, Oracle issues "ioctl(fd, VX_SETCACHE, VX_DIRECT).".The ioctl effectively disables VXFS caching, and renders considerable IO slow down compared to 10.2.x  for IO events like "db file sequential read" and "db file parallel read".