Re: Old linux lore no longer applies

From: Mladen Gogala <>
Date: Thu, 22 Mar 2012 22:26:36 +0000 (UTC)
Message-ID: <>

On Thu, 22 Mar 2012 14:42:58 -0700, joel garry wrote:

> Have you looked for hidden parameters like (the 10g) > _db_file_optimizer_read_count ?

Yes, I have, but I am very reluctant to play with these. Here is the list, if someone else feels up to the task:

  2 from x$ksppi
  3 where regexp_like(KSPPINM,'^_.*read.*count','i')   4* order by 1



multiblock read count for regular clients


number of noncontiguous db blocks to be prefetched


multiblock read count for regular clients


read-only violation array max count

read-only violation array per module max count


multi-block read count for sort

6 rows selected.

Elapsed: 00:00:00.03

Received on Thu Mar 22 2012 - 17:26:36 CDT

Original text of this message