I think it was the smallest group so far which is not surprising considering that Monday has been the least popular day in our internal poll. We had a tad less than 20 people but very good size for the informal discussion of Oracle 11g adoption that took place at the second half of the meetup.
Turned out that there are very few people running 11g in production. Besides us at Pythian with number of clients on 11g, we’ve had only couple people I think including Carl Young from Metcash. Carl shared their experience of running a multi-terabyte data-warehouse on Oracle 11g and how the migration happened. Thanks a lot Carl for your insights!
If you haven’t seen the case study from Oracle about this migration — see what benefits Metcash had with 11g migration. I myself took note of few areas — Query Cache helped a lot on dimension tables lookups and some popular reports, Materialized Views invalidation problems reduced, CBO becomes smarter.
Some of the things to pay attention to in 11g — Oracle Warehouse Builder 11g (18.104.22.168) has actually less features than the latest OWB 10g release. If you look at 22.214.171.124’s list of bugs fixed (Metalink Note 601739.1), you would see a few dozen bugs on “Wrong Results” — those bugs are most worrying, of course. Many of them occur at the very specific circumstances. Particular attention for DW environment are bugs related to predicate push — can make your materialized views end up with wrong aggregates! Well, very few excuses to stick to 126.96.36.199 now.
Regarding the even in general, if I may borrow a response from one of the members to quote here:
Illuminating presentation by Alex, good questions and answers from participants. I was uncertain whether to go from 9i to 10g or 11g. This information and experience from other users has now helped me come to a decision to go straight to 11g.
Well, I should say mission accomplished!
For those of you who are not in Sydney or haven’t had a chance to attend, here are the slides from the meetup. I should note that the content is based on Christo Kutrovsky’s presentation that he delivered at the Oracle Open World 2007. Christo was scheduled to give a modified version at the IOUG Collaborate 2008 but couldn’t attend it being in Dubai at that time so I was doing it instead and took his slides as the basis. But I digress…