Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post about 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 12.1.0.2 and note 1645862.1 is for 11.2.0.4, but there is one for every version from 11.2.0.2 (currently to 12.1.0.2, 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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s