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.
Footnote: my hosts for the event gave me a couple of souvenirs of the visit – and because we were in Switzerland, one of them had to be a little Swiss Army pen-knife. Since I only travel with cabin-luggage I thought this might be a problem, but the blade was only two inches long and the rules about such things have changed over time so I decided to risk taking it to the airport. On the land-side of the security scanners I showed the pen-knife to the security guard and asked if it was okay to take it through – he said yes, so I dropped it into the little plastic box along with my toothpaste; but by the time it came out at the other end of the scanner the rules must have changed because the security guard on the air-side took it, demanded my boarding pass, disappeared for a couple of minutes, and came back with just the boarding pass. (If I don’t show up at ODTUG this year, it will probably be because the Swiss have put my name down on a list of international arms smugglers – alternatively, maybe there’s just a couple of Swiss security agents who have a side-line in second-hand Swiss Army pen-knives.)


I had a similar incident. I used to work for a Swiss company and they gave me a neat little Swiss Army pen-knife. I used to keep it in my training bag for cutting tape when I had to tape up injuries (toe and fingers etc). On one trip I switched bags and used my training bag for hand luggage and didn’t check its contents. Sure enough, the security check noticed it and it was removed.
Slightly more worrying, I got to the destination and noticed I had a lock knife in my toiletry bag. Gosh, I sound like Kevin Closson…
Cheers
Tim…
Comment by Tim Hall — February 24, 2012 @ 3:01 pm UTC Feb 24,2012 |
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 |