Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post with some more information related to this topic.

As I wrote in the post I mentioned above, most of the issues we run into after upgrading are performance related. I guess this is the case because it’s one of the most complex components of Oracle and it’s very very difficult (if not impossible) to test everything.

Once a new version is out, people are starting to play with it, and after a while use it on test and then production systems. During this time, bugs are identified and fixed. With these issues Oracle behaves responsibly and provides a lot of information about problems (I even wrote in the past that I like to read notes talking about bug fixes).

With optimizer issues, they are doing the same, so MOS has specific notes about optimizer bugs and issues by version. The noted are titled: “Things to Consider to Avoid Poor Performance or Wrong Results on <version>”. Note 2034610.1 for example is for and note 1645862.1 is for, but there is one for every version from (currently to, but I guess they will have one for 12.2 soon).

My recommendation is that before you upgrade, take a look at this. That way you will know about well-known bugs in the new version, and will be able to avoid them before going live.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s