Forwarding the mail to the grp...
==========
Don't set db_file_multiblock_read_count to a higher value!
Indexes won't be used then caused by a cheaper access to full- table scans!
If you'd like to change optimize-behaviour try setting

Optimizer_idex_costs_adj
Optimizer_index_caching

RH


Oracle LazyDBA home page