There’s a very useful posting from Coskan Gundogar about tracking down a problem to do with an 11g upgrade.
The method basically revolves around a quick check for “known issues” that might be relevant by looking at the dynamic performance views v$system_fix_control.
When I read Coskan’s notes I had forgotten that I had written a short item about this myself about a year ago where I listed the relatively small number of items available in 10.2.0.3. The list is up to 551 in my copy of 11.2.0.2.
[...] and fixes to the optimizer that take place I decided to take a look at recent developments in the “fix control” list, and the “optimizer environment” parameters. Here’s a breakdown of the [...]
Pingback by Upgrades « Oracle Scratchpad — February 20, 2012 @ 5:53 pm UTC Feb 20,2012 |