Monday May 23, 2011

Time Zone Upgrade might be slow

One of the best things with my role in Oracle's Upgrade Development is:
I work with customers - and I learn a lot from customers.

This is an issue Richie and his team from Accenture in Ireland brought to my attention. I try to support them currently in an EBS database upgrade. And he did highlight a potential issue with the post upgrade time zone change to me:

Time ZonesBug 10209691 - slow performance on ALL_TSTZ_TAB_COLS
Workaround: alter session set "_with_subquery"=materialize;

All together the upgrade of an Oracle 9.2.0.8 EBS 11i database takes approx 30 minutes. And we still do recommend upgrading the Time Zone Data post upgrade as first of all we use the data type TIMESTAMP WITH TIMEZONE internally in the dictionary and - more important - the scheduler relies on correct settings. Otherwise it could happen that jobs don't get executed.

Of course Roy and me added this information to the slides already ;-)


About

Mike Dietrich - Oracle Mike Dietrich
Master Product Manager - Database Upgrade & Migrations - Oracle Corp

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite or remotely with reference customers. Acting as interlink between customers/partners and the Upgrade Development.

Follow me on TWITTER

Contact me via LinkedIn or XING

Search

Archives
« September 2015
SunMonTueWedThuFriSat
  
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Oracle related Tech Blogs
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
Workshop Map
This week on my Rega & Pono
Upgrade Reference Papers