Re: The responsible

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
self-defeating.

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




Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
--
http://www.freelists.org/webpage/oracle-l



Other related posts: