Re: The responsible

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 07 Feb 2006 11:58:47 -0700
Message-Id: <6.2.3.4.2.20060207115617.04a8deb0@pop.centrexcc.com>

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

Received on Tue Feb 07 2006 - 12:58:47 CST