Tuesday Jan 01, 2013

Happy New Year!!! And my top ten 2012 songs ...


Happy New Year

to all of you, your families and friends wherever you live on the globe :-)



And - similar to last year - here's my list of the best 2012 songs based on the CDs or LPs I did purchase that year - and I didn't buy much music this year but did focus on older stuff I had on my iPod for quite a while or just started listening. For instance I did get two UFO compilations, The Chrysalis Years and the The Decca Years, after listening to Try Me in the best bar on the globe.

But back to my top 2012 releases and best songs.

Anathema - Weather Systems


This is my true number 1 album of 2012. I know Anathema from Liverpool since 1996 and had the chance this year in early November to see them live for the first time. And even two months after that concert I would still claim that this was the best concert I've ever been to. Period. Just by they way: this album became also the 2012 critic's choice of UK's Prog magazine. And there's a reason for that ;-)

Listen to:
Untouchable Part 2 and The Gathering Of The Clouds


Katatonia
- Dead End Kings


Similar to Anathema Katatonia do exist since the early 90's. And back then their style was way harder than today. Bought this CD at Rasputin Records during OOW in San Francisco and did listen to it almost every second day since then. Don't get distracted by the strange cover - some bands need to have such an artwork.

Simply listen to these two songs:
Lethean and Racing Heart


Steve Wilson - Get What You Deserve - Live in Mexico City


Very rarely I buy DVDs or BluRays as I like more listening to music than watching it. But this one is an exception (and it has the full concert on a double CD included as well). Steve Wilson is the mastermind of Porcupine Tree, one of my true favorite bands. And he seems to sleep just 3 hours per night if you look at all the projects he had done in the past 3 years. This DVD/CD/BluRay is the entire concert of Steve Wilson's solo project after releasing Grace For Drowning in 2011. And sonically as well as visually this concert is really great.

Listen to Harmony Korine and Part of Me


Baroness - Yellow & Green


Baroness 2012 release is my "almost" number 1 album of 2012. Actually it's two albums, Yellow and Green combined into one release. I did purchase that after reading a review in German magazine Der Spiegel a while back in July 2012. The author called it The Album Of The Year ... in July. The band is based in Savannah, Georgia, exists since 2003 and had been already on tour in the past supporting Metallica. I got really touched by the variety of styles, the rough rawness and power combined with sweet harmonies - wow! Some songs simply blew me away :-)

Listen to:
Take My Bones Away and Twinkler and Psalms Alive


Die Toten Hosen - Ballast der Republik


Just a month ago a documentary in German TV did show the entire career of Die Toten Hosen now spanning over 30 years. They started as a punk band in Düsseldorf in 1982 but today they are playing true rock music. Plenty of their songs were frequently played some 20 years ago at our school parties. It's still not their best album ever (that's Ein Kleines Bisschen Horrorschau, the German interpretation of Clockwork Orange with Hier kommt Alex)  but I did listen to some of their songs very often when walking through San Francisco this year at OOW - and I have them on heavy rotation in my car for longer drives (sometimes there's no speed limit on German Autobahns) ;-)

Listen to Altes Fieber and Tage Wie Diese

Wednesday May 02, 2012

Behaviour Changes Oracle 8i to 11.2 + New Features Oracle 11.2 + refreshed Upgrade and Migration Slides

We have uploaded refreshed and new slide sets:

Tuesday Apr 03, 2012

New Slides - and a discussion about Dictionary Statistics

First of all we have just upoaded a new version of the Upgrade and Migration Workshop slides with some added information. So please feel free to download them from here.The slides have one new interesting information which lead to a discussion I've had in the past days with a very large customer regarding their upgrades - and internally on the mailing list targeting an EBS database upgrade from Oracle 10.2 to Oracle 11.2.

Why are we creating dictionary statistics during upgrade?

I'd believe this forced dictionary statistics creation got introduced with the desupport of the Rule Based Optimizer in Oracle 10g. The goal: as RBO is not supported anymore we have to make sure that the data dictionary has fresh and non-stale statistics. Actually that would have led in Oracle 9i to strange behaviour in some databases - so in Oracle 9i this was strongly disrecommended.

The upgrade scripts got hardcoded to create these stats. But during tests we had the following findings:

It's important to create dictionary statistics the night before the upgrade. Not two weeks before, not 60 minutes before your downtime begins. But very close to the upgrade. From Oracle 10g onwards you'd just say:

$ execute DBMS_STATS.GATHER_DICTIONARY_STATS;

This is important to make sure you have fresh dictionary statistics during upgrade for performance reasons. Tests have shown that running an upgrade without valid dictionary statistics might slow down the whole upgrade by factors of 2x-3x.

And it would be also a great idea post upgrade to create again fresh dictionary statistics when you've did suppress the stats creation during the upgrade process. Suppress? Yes, you could set this underscore parameter in the init.ora:

_optim_dict_stats_at_db_cr_upg=FALSE

to suppress the forced dictionary statistics collection during an upgrade. We believe strongly that (a) people using the default statistics creation process which will create dictionary statistics by default and (b) create fresh stats before upgrade on the dictionary. Therefore we find it save once you have followed our advice to use the underscore during upgrade. And we've taken out that forced statistics collection during upgrade in the next release of the database.

Please note: If you are using the DBUA for the upgrade it will remove underscore parameters for the upgrade run to improve performance - which is generally a good idea. So you'll have to start the DBUA with that call:

$ dbua -initParam "_optim_dict_stats_at_cb_cr_upg"=FALSE

-Mike

Monday Mar 19, 2012

Upgrade Workshop in Wellington - Recap

Wow! Wellington is really a wonderful city - except for the weather situation ;-) But it was the first time that Roy and me did arrive to a workshop with a ferry boat. We flew in on Friday to Christchurch (btw, this was the longest customs and border control I've ever went through - and I traveled to Israel by bus via Allenby Bridge from the West Bank some years ago - it took us two hours to go through immigration and customs in the night from Friday to Saturday) and drove up the Southern Island. Very nice :-) Great landscapes, great wines and great people!


I'f you'd like to download the slides please download them from the Slides Download section to your right.

And next time you'll have to ask more questions :-) Don't be this shy - Roy and me (usually) don't bite :-)

-Mike



Wednesday Mar 07, 2012

Upgrade & Migration Workshops Down Under

Time flies ... and the Database Upgrade and Migration Workshops in Australia and New Zealand come closer and closer. It has been exactly two years ago since Roy and me had run the Upgrade Workshop in Perth and Melbourne. In 2010 visiting Australia was part of our Asian workshop route. But this time we'll fly the looooooooooooong way (ouch ... I'm definitely not looking forward to my eco seat in cattle class for the 18 flight hours down to Perth - and, even worse, to the 22 hours with 2 stops on the way back from Sydney) down just for Australia and New Zealand.

The local Marketing group and our colleagues from Presales and Support had done a really good job - and due to the high registration rates the events in Melbourne, Wellington and Sydney had been moved now to external vernues :-) Thanks to the local folks for their hard work!!!

All registration links are now open again. Grab your seat if you haven't registered yet or tell your colleagues. It's a technical workshop. Just 2 out of 478 slides have marketing content :-)

  • 13-MAR-2012: Perth ... Registration
    Oracle Corporation - Level 2, 66 Kings Park Rd - West Perth, WA 6005 - Theatre/Presentation Room

  • 15-MAR-2012: Brisbane ... Registration
    Oracle Corporation - Level 14/300 Ann Street - Brisbane, Australia - Brisbane room

  • 16-MAR-2012: Melbourne ... Registration
    Cliftons Melbourne - Level 1, 440 Collins Street - Melbourne, VIC 3000

  • 19-MAR-2012: Wellington ... Registration
    Rydges Wellington - 75 Featherston Street - Wellington, New Zealand

  • 21-MAR-2012: Sydney ... Registration
    Cliftons Sydney - 190-200 George Street - Sydney, NSW 2000

We are really looking forward to meet you next week or the week after - CU there :-)

P.S. The picture on top if from Cottesloe Beach near Perth - unfortunately next week we won't have enough time to spend an hour or so there ...

About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

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

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers