Re: db file scattered read

From: Yong Huang <yong321_at_yahoo.com>
Date: 5 Oct 2001 20:53:15 -0700
Message-ID: <b3cb12d6.0110051953.4c6cf3e1@posting.google.com>

The best tuning in your case is tuning SQL statements. Look at explain plan and rewrite them or add hints. At the same time make sure you have updated statistics (if you're not using RBO), and properly built, well structured indexes. If you can't control the third-party SQLs, control the indexes.

System tuning always comes second. If you do want to play with the multiblock read count, don't go to two extremes. Benchmark with various values in the middle.

Yong Huang
yong321_at_yahoo.com Received on Fri Oct 05 2001 - 22:53:15 CDT