I’ve just spent a couple of days in Switzerland presenting seminar material to an IT company based in Delemont (about 50 minutes drive from Basle), and during the course I picked up a number of new stories about interesting things that have gone wrong at client sites. Here’s one that might be of particular interest to people thinking of upgrading from 10g to 11g – even if you don’t hit the bug described in the blog, the fact that the new feature has been implemented may leave you wondering where all your machine resources are going during the overnight run.
Advisors are relatively new = buggy. As part of our standard 11.2.0.2 setup we switch of resource manager and db cache advisor. For 10r2 we switch of segment space advisor. Some of those problems we hit ourselfs, some problems are reported by oracle support. Anyway, it’s nasty to get instance crashed by advisors which are just optional for database.
Comment by laimis (lnd) — February 27, 2012 @ 8:41 am UTC Feb 27,2012 |