General discussion

Locked

Problem with Oracle optimizer (8.0.5) on

By thorarinn_andresson ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Problem with Oracle optimizer (8.0.5) on

by sglubka In reply to Problem with Oracle optim ...

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.

Collapse -

Problem with Oracle optimizer (8.0.5) on

by thorarinn_andresson In reply to Problem with Oracle optim ...

Poster rated this answer

Collapse -

Problem with Oracle optimizer (8.0.5) on

by thorarinn_andresson In reply to Problem with Oracle optim ...

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums