Re: Physical reads on table very high.

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: 2000/07/15
Message-ID: <8kp68g$r8u$1@nnrp1.deja.com>#1/1

Hi.

Try setting multi_block_read_count to 8 instead of 32 ( that solved the same problem for me ).
At any case - on UNIX ( as far as I know ) the I/O unit is 64K only, so there is no reason to use multi_block_read_count greater than 64K/db_block_size.

HTH. Michael.

In article <2dbec54e.2659c439_at_usw-ex0105-037.remarq.com>, Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid> wrote:
> Thanks! multi_block_read_count is 32, will try some of the other
> stuff you mentioned. Version is 8.0.4.4.0. Everything in
> J.D.Edwards is CHAR no VARCHAR2 makes for fun when trying to
> optimize queries, somtimes value in table is ' XXX' and in
> related table will be 'XXX '. Block size is 8K. Yes you are
> correct I can't change the query because it is 3 rd party. Just
> want to be sure there was some challenge to this and I was not
> being stupid.
>
> -Ethan
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jul 15 2000 - 00:00:00 CDT