Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> vxfs and Oracle db_file_multiblock_read_count

vxfs and Oracle db_file_multiblock_read_count

From: Luis Santos <lsantos_at_pobox.com>
Date: Fri, 09 Feb 2001 15:14:30 GMT
Message-ID: <9611gb$pr$1@nnrp1.deja.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/
Received on Fri Feb 09 2001 - 09:14:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US