Re: I/O and db_file_multiblock_read_count

On 12/08/2006 03:46:00 PM, Kevin Lidh wrote:
> I was reading an article about the appropriate setting for
> db_file_multiblock_read_count.  I'm on a HP-UX 11.11 64-bit system with
> Oracle 9.2.0.7.0.  The original value was 16 and I bounced the database and
> ran a million record full-scan test (10046 trace) and then set the value to
> 128 (max value) and re-ran the test.  Although I did have less calls to 'db
> file scattered read' (140 compared to 1008), the time to get the same number
> of blocks was longer.  A random example from the trace files looks like
> this:

Of course, you did run dbms_stats.gather_system_stats?

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Other related posts: