Tuesday, February 24, 2015

11.2.0.4: Parse time can be increased for same query on 11.2.0.3

If you have been in the Oracle space for any amount of time you will know that a new version or the latest files can actually introduce problems, but even knowing that it is surprising to read MOS article "Increased Parse Times for Queries Using Subqueries Containing Multiple OR And AND Statements on 11204 Compared to 11203" from note 1980761.1!  Not only do we learn what is going on here, but we get to learn a few ALTER SESSION commands that we may not have otherwise had to know about plus this is a good warning that your performance may be suffering for no other reason than you are on the latest patchset of 11gR2!

No comments:

Post a Comment