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 -> Re: vxfs and Oracle db_file_multiblock_read_count

Re: vxfs and Oracle db_file_multiblock_read_count

From: Alain Walrant <alain.walrant_at_oracle.com>
Date: Mon, 12 Feb 2001 23:38:41 +0100
Message-ID: <3A8865F1.B76F8873@oracle.com>

What's the DB_BLOCKSIZE value in the init.ora file ?

Luis Santos wrote:

> 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 Mon Feb 12 2001 - 16:38:41 CST

Original text of this message

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