Re: vxfs and Oracle db_file_multiblock_read_count

Hi Luis,

I believe that direct I/O only works with the OnlineJFS product, not the base. If you just have BaseJFS then your mountoption will be silently ignored.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Luis Santos <lsantos_at_pobox.com>

   Hi!

   We use Oracle 8 (8.0.6.2.0) and HP-UX 11. All our Oracle fs vxfs file systems.

   I discovered using the tusc utility that HP-UX is doing 8K reads on datafiles, regardless the Oracle db_file_multiblock_read_count parameter, which is tuned to do 256K reads.

   We read that we must use the direct_io options of vxfs, mounting it with the parameter convosync=direct

   Well, we did everything right but the reads are still been done in 8K chunks.

   Any hint or help is welcome!

--
   Luis Santos
   Oracle DBA


Sent via Deja.com
http://www.deja.com/