Discussion Locked

Problem with Oracle optimizer (8.0.5) on

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Has anyone experienced problems with Oracle on NCR.
One of our customers installed Oracle 8.0.5 on their NCR machine. It turns out that there seems to be a bug in the Oracle Rule based optimizer. Under load the db started to use wrong index, even index that did not have the column we vere querying on.

We tryed changing the degree of the tables, from 4 to 1, but no luck.

Oracle has not given us any answer to this problem.

We are unvilling to switch to cost based optimizer at this pointbecause it would involve heavy testing.

Regards,
Thorarinn Andresson.

3 replies

by sglubka

Welcome to the world of Oracle optimizers. I have run into similar problems on various platforms / versions of Oracle. The best thing to do is either remove "unselective" indexes, or put a hint in the sql statement.

This discussion is closed to new replies.