Thursday Feb 27, 2014

CSX Corporation Upgrades Databases 2x Faster With Oracle Real Application Testing

Wow - one of our reference projects went into the Yahoo Finance webpages. Carol Tagliaferri (my direct manager) worked with CSX, one of the largest US based railway companies, over a longer period together with the RAT team, and helped CSX to successfully upgrade and migrate their database landscape to Oracle Database 11.2.
Plus: We did present about CSX at Oracle Open World 2012 as this project is a perfect showcase for:

(a) an Upgrade project with many databases
(b) over a longer period of time
(c) using Real Application Testing decreasing the testing effort by factors!

Read the published article on Yahoo Finance!

And that is what Maritza Gonzalez, Technical Director at CSX said:

“The Real Application Testing tool provided a comprehensive and flexible solution for assessing the impact of the Oracle 11g database upgrade  into CSX systems.  At CSX we were able to capture real production workloads,  replay it in the 11g environment,  identify poor performing  queries and, fine tune these queries in a test environment  before the production implementation.“

 More details on the actual project are included in our OOW 2012 talk (slides 35-42).

Graphics are courtesy linked directly from the CSX public webpage

Tuesday Feb 25, 2014

Simplify your Migration from AIX to Solaris

Oracle Solaris 11There is a brand new white paper available that will be of interest to anybody contemplating a database and/or application migration from AIX to Solaris. Simplify the Migration of Oracle Database and Oracle Applications from AIX to Oracle Solaris gives a good description of the steps involved in planning and executing a migration project, along with the benefits you can expect to achieve and a solid example of migration using Oracle Data Pump, complete with scripted steps.

Of course, if your migration will include moving up to Oracle Database 12c, don't forget to sign up for Mike's webcast on February 26!

Monday Feb 24, 2014

Upgrade Webcast - Wednesday, Feb 26 - 10am CET

 If you'd like to get an overview about  Upgrade/Migrate/Consolidate to Oracle Database 12c then please register and attend our free webcast this Wednesday, February 26 at 10am CET:

Date: Wednesday, February 26, 2014
Time: 10:00 AM CET


Register yourself here!


Wednesday Feb 19, 2014

Thank You for flying with "Hello Kitty" ;-)

Yesterday Roy and I flew directly after the workshop in Seoul to Taipeh in Taiwan. It's our first time in Taiwan - and the flight to Taipeh with EVA Airlines was quite surprising ;-) I didn't took a picture in the bathroom ... 

"Thank You for flying with Hello Kitty!".


Tuesday Feb 18, 2014

Some impressions from Austalia

Being again in Australia was - again - a great experience. If only traveling to Down Under wouldn't take this long ... :-) But thanks to everybody who showed up - and sorry to those which got a "Sorry, it's sold out already!" message. It was pure fun to talk to you and we'll hope to get a lot of people to move onwards to Oracle 12c as soon as possible. Don't forget: 11.2 will go out of Premier Support in less than 12 months from now on. Of course we'll return one day - and certainly our colleagues from Oracle Australia will be able to assist you as well regarding your upgrade and migration efforts.

Please feel free to grab the slides via this link:
Upgrade, Migrate & Consolidate to Oracle Database 12c
[30MB PDF]

And here are some impressions from a RAINY weekend in Sydney ;-)


Thursday Feb 13, 2014

Collaborate '14 Early Bird Registration ends Today!

Mike and I are in Sydney, Australia delivering an upgrade workshop today, but I am also looking forward to the Collaborate '14 conference in April. I will have a talk about upgrading to Oracle Database 12c, and of course there will be plenty of information about Oracle Multitenant, applications, and other aspects of your Oracle environment. 

Collaborate 14 banner

Early bird registration ends today, so if you want to save some money and attend a conference that is always chock full of good technical presentations, register today!

Tuesday Feb 11, 2014


Just learned something new I couldn't find actually in the doc at the first glance:

There's a new init.ora parameter introduced in Oracle Database named:

By default it is set to FALSE and the parameter got introduced because not only the external use of Oracle GoldenGate requires a valid license but also the use of the internal APIs. For example, XStream provides high performance APIs that enable client applications to receive and send real-time data changes from an Oracle database. Other APIs were added for encryption support, trigger suppression, etc. None of these APIs are licensed with the Oracle database itself - the license is included with an Oracle GoldenGate license, and most of the APIs are not public.

So please make sure if you turn ENABLE_GOLDENGATE_REPLICATION=TRUE that you'll need to have a valid Oracle GoldenGate license in place.

That will apply to 3rd party products such as Dell Shareplex as well in case they'll switch it to true.


Addition: As a customer talked to me about that during the Sydney workshop last week I'd like to point out that this paramater does not effect the use of Oracle GoldenGate as a stand-alone tool but only the internal interfaces inside the database.

Friday Feb 07, 2014

Airfare Pricing vs. Oracle Multitenant for DBaaS?

I'm currently evalutating flight options to and from India for the 3 workshops in March in Mumbai, Delhi and Bangalore.

As everything at Oracle is fully self-serviced I've got stuck in our booking tool for over an hour now just wondering ... wondering ... wondering ...

For instance I wonder why an Economy class ticket with Lufthansa and Swiss to Mumbai and return from Bangalore will cost over EUR 5000 (no joke!!!) even though Swiss is a 100% subsidiary of Lufthansa.

whereas I can fly a slightly different route with Delta Airlines only from Germany to the US and back to Amsterdam and then further to Mumbai for less than half of the price - even though this includes different airlines as well (KLM and Delta) and will take more than twice as long and almsost triple the distance:

Roy (kudos!) and I had this great idea if YOU as a customer would match airline pricing strategy to your internal Database-as-a-Service (DBaaS) strategy?

  • First of all you make the price dependent on the time frame one odered a fresh PDB
    • The earlier the cheaper - except for the last week before a fixed date as now you'll have to max out allocated resources
  • Second you will have to make it completely intransparent so nobody will be able to proof against your pricing strategy being insane
  • Third you should make the price also depend on the process somebody used to order a PDB
  • Furthermore you should introduce some extra components such as "serviced by a lead DBA" will make it more expensive
    • Same for "served by another companies expert" - even though you own that company as well
  • And don't forget to include some components which will give yourself perfect flexibility such as "The enegery prices climbed up this week so unfortunately we'll have to make the provisioning and operation of a PDB more expensive" - and never take back this price growth (or if you do so then just by a portion of it)
    • Or tell people they'll get a special price with the only downside that the department working with this PDB will have to get up to work now at 3:40am in the morning and the PDB won't be accessible after 9am anymore

Wouldn't this be a wonderful pricing model?

Of course you read my irony and sarcasm. You know the answer: You'll be in real trouble if you'd offer such a service and pricng internally to anybody. But I'll never understand airline pricing models ...



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

Based in Germany. Interlink between customers/partners and the Upgrade Development. Running workshops between Arctic and Antartica. Assisting customers in their reference projects onsite and remotely. Connect via:

- -


« February 2014 »
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Viewlets and Videos
Workshop Map
x Oracle related Tech Blogs
This week on my Rega & Pono
Upgrade Reference Papers