Re: The responsible

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: juancarlosreyesp@xxxxxxxxx
  • Date: Tue, 07 Feb 2006 11:58:47 -0700

At 11:35 AM 2/7/2006, Juan Carlos Reyes Pacheco wrote:

> What works well with this version of the optimizer won't necessarily
> work well with a future version.

I didin't upgrade or touch anything it was on oracle 9.2, simply one
day the parameter necesaries to get used index in small t ables became

In Oracle 9i you should be looking at gathering system statistics instead of messing with OICA in order to give the cbo information about the differing speeds of single and multi block reads


Wolfgang Breitling
Centrex Consulting Corporation

This email has been scanned by the MessageLabs Email Security System.
For more information please visit ______________________________________________________________________

Other related posts: