Mike may be done traveling for a while, but I have more than a bit of travel coming up. Next week I will be delivering four talks at OpenWorld Beijing 2010.
I’m looking forward to returning to Beijing. Last time Mike and I saw the usual tourist sites and plenty of interesting food. One place to which I will definitely try to return this time is Da Dong Duck, a wonderful restaurant for (what else?) Peking Duck.
Oh yes, my talks, I almost forgot :-). Here are the details:
Session Title: The Most Common Upgrade Mistakes (and How to Avoid Them)
Session ID: 1716
Session Schedule: 12/15/10
Time: 10:45 – 11:30
Location: Room 506 AB
Session Title: Get the Best out of Oracle Data Pump Functionality
Session ID: 1376
Session Schedule: 12/16/10
Time: 16:30 – 17:15
Location: Room 311 A
Session Title: What Do I Really Need to Know When Upgrading?
Session ID: 1412
Session Schedule: 12/16/10
Time: 14:30 – 15:15
Location: Room 308
Session Title: Patching, Upgrades, and Certifications: A Guide for DBAs
Session ID: 1723
Session Schedule: 12/16/10
Time: 11:45 – 12:30
Location: Room 506 AB
We will also have a demo booth to talk about upgrading to Oracle Database 11g Release 2. So, if you’ll be attending OpenWorld Beijing 2010, please stop by one of my talks or the demo booth!
—
Just an add-on as Roy has sent me this picture today from his dinner at Da Dong Roast Duck:
Roy and Mike,
I went to the OpenWorld Latin America 2010 and an Oracle ACS professional told me about this Blog.
I’m looking for a documentation with the changes in SQLs when upgrading to Oracle 11g. For example, in Oracle 9i the distinct ensures ordenation. In Oracle 10g, that’s not always true. Is there anything similar when upgrading from 10g to 11g?
Do you have any information on this?
Thanks,
Caio
Hi Mike,
Will you be recording this? 🙂
Regards,
Roy
Hi Cairo,
There will always be behavior changes when moving from an earlier release to a later one. The best sources for this information are the Upgrade Advisors (start with My Oracle Support note 250.1). These leverage the information that is in the Upgrade Companion notes (see MOS note 785351.1 for upgrades to 11gR2), presenting it as a workflow for the upgrade.
If you follow the steps outlines in the Upgrade Advisor and/or Upgrade Companion, that will be your best source of information about changes to SQL, or about other behavior changes in areas such as security or the optimizer.
I hope this helps!