ODC Appreciation Day: Using PIVOT for Unknown Dimensions

This post goes to #ThanksODC (formerly known as #ThanksOTN) which is initiated by Tim Hall (aka OracleBase).
But first, story time of this. I prepared this bunch of code (continue reading below please), because of being stubborn of being performance enthusiast. While I was working as a consultant, I was first invited to increase performance of an ETL which is already running on production and was running at least 12 hours per run (monthly). We did our best with the features of the ETL tool, paralleled queries, and managed to reduce it to 8-9 hours. But, “it-was-not-enough”!
Continue reading

Advertisements

After the great #OGhTech17 Conference

It was a long day again (woke up at 3:30am in the morning) to my 7:05 flight to Shiphol Airport. Then took train to Amersfoort. Luckily, the hotel I found was still there with my door card in the reception (this means no early check-in). I get in the elevator, but what? I need to keep my finger on the floor (mine was only 2) to get it moving and snails will go to 2nd floor faster even using the stairs. I still wonder why there is an emergency button, where you need to leave your finger from the floor button to press emergency button. I believe it is there because of regulation. 🙂 Continue reading

#OTNEMEATour Fifth Leg Düsseldorf

After a early flight again (woke up at 3:30am to catch the 6:50am flight), I landed to Düsseldorf and went to my hotel with one single train and admired the state of public transportation in Düsseldorf.

Gladly, my room was ready and I am off to see the city and attend the speakers’ dinner afterwards. below are some good sightseeings which represents Düsseldorf city. Continue reading

#OTNEMEATour Third Leg Ljubljana

Touched down to Ljubljana around 8am in the morning and it took me not more than 20 minutes to reach to the hotel with hotel’s shuttle service. I’m glad that my room was ready and go out to see the city immediately. First, I went to three-bridges, then to an ancient castle then to market place and discovered a shopping mall and spent rest of the day there. Ljubljana is a great city for touristic attractions and it is so easy to go everywhere with bus (busses are working almost 24 hours a day).

Ljubljana city visit (Castle Tour)
Ljubljana city visit #1
Ljubljana city visit #2

I came to conference venue – Austria Trend Hotel – right on time with public transportation. And met with Björn Rost, Jure Bratina and Frank Dernoncourt at the gate of the hotel. There were more than 60 attendees and worth 1000s. Questions, attendance and interaction to sessions were amazing. One of the local session, which has to be before lunch, was cancelled. And we decided to make a panel session just before the lunch and we still answering questions although it was overtime. Kudos to audience!!!

Eventually, Björn had 3.5, I had 2.5 and Frank had 2.5 sessions at all, and we – as techie guys – all love to talk.

Ljubljana Conference Day

#OTNEMEATour Second Leg Baku

It was my first time using Istanbul Ataturk Airport (IST) as a transferring passenger and but my flight to Helsinki to Baku has a stop about 1.5 hours in Istanbul. So I managed at 5:20 am to Haydar Aliyev Airport (GYD) and switch to my hotel. Continue reading

#OTNEMEATour First Leg #Harmony17

After reaching to Helsinki, sleeping on 3 complete empty seats lied down by luck (I left my emergency seat for this reason), I made a small city tour and reached the meeting place (in front of Presidential residence – intentionally mentioned this because it is the real residential palace of Finland President with non-moving soldiers in front of the building) and met with Frits Hoogland and Patrick Barel. Speakers dinner is very well organised on a ancient trade wooden boat and sailing with the power of the wind (rarely with engine when we are behind the schedule) and we were all sailor-man (in real). In spite of sun, it was about 4-5C and some of us was downstairs in order not to get cold because of freezing wind. Please click pictures to enlarge. Continue reading