Re: Old linux lore no longer applies

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 22 Mar 2012 22:26:36 +0000 (UTC)
Message-ID: <pan.2012.03.22.22.26.36_at_gmail.com>

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:

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

---

KSPPDESC

---

_db_file_exec_read_count

multiblock read count for regular clients

_db_file_noncontig_mblock_read_count

number of noncontiguous db blocks to be prefetched

_db_file_optimizer_read_count

multiblock read count for regular clients

_read_only_violation_max_count

read-only violation array max count

_read_only_violation_max_count_per_module
read-only violation array per module max count

_sort_multiblock_read_count

multi-block read count for sort

6 rows selected.

Elapsed: 00:00:00.03

-- 
http://mgogala.byethost5.com

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