OTN APAC 2014 : Shanghai to Tokyo

Not the best night of sleep last night. During the day I noticed the load time for pages on my website is really slowly in China because it hangs waiting for a Google Javascript file to load, which eventually does a timeout. Once the timeout happens the page continues to render. That means it takes over a minute to load the page. Since I couldn’t sleep I decided to get out of bed and fix it. It turned out the Javascript file just renders the “Powered by Google” text in the search box, so I removed that and the pages now load fast. There are still some asynchronous calls to Google code that timeout, but those don’t block the page rendering, so I don’t care about them. The site is usable now… 🙂

After breakfast I got a taxi to pick Bjoern up from his hotel, before heading off for the airport. It was a quick flight, about 2:35, so it was pretty small compared to what we’ve done so far. I was sitting near some people who were talking really loud. I had my earphones on almost full volume, but the people were still clearly audible. The landing in Tokyo was quite hard, which prompted one of the loud women to wail somewhat, then the woman across the aisle was sick in a bag. I didn’t think the landing was that bad… 🙂

From there we got the Narita Express into town and a short taxi ride to Bjoern’s hotel. He dropped his stuff off, then we got a taxi over to my hotel, where most of the other speakers are staying. We took a walk around the local area to look for food, but I got scared as everything looked like it contained meat or fish, so I got some fries from McDonalds. I will try some proper food tomorrow, when we have someone who speaks Japanese to help make the choices. 🙂

I’m a little worried about my hotel room as the bathroom has been taken over by a Dalek.

Toilet

Cheers

Tim…

OTN APAC 2014 : Journey from Perth to Shanghai

As I wrote previously, after some drinks and food after the Perth conference, Bjoern and I went to the airport to start the trip to Shanghai. Fortunately Bjoern has gold status so he could get into the lounge and sign me in, which made the long wait for the first flight much easier.

The first flight was about 5 hours to Singapore. I didn’t sleep, which was a pity. We were a little delayed, so the layover in Singapore wasn’t too long. Then we boarded the flight to Shanghai, which was another 5-ish hour flight. I did manage to sleep for between 1-2 hours on this flight, so if my maths is correct I got about 2 hours sleep in the last 38-40 hours. I arrived at Shanghai feeling pretty terrible.

MagLev SpeedOn arrival at Shanghai airport we took the Maglev train to the city. Its top speed for this journey was 430kph. Crazy fast! We then switched to the {metro | subway | tube} to get us right next door to Bjoern’s hotel. I got a taxi from there to my hotel. I’m staying in the conference hotel, so life should be simple…

I’ve ducked out of the dinner tonight (sorry folks) because I’ve got to get some sleep or I simply won’t be able to do anything at the conference tomorrow. Bjoern sleeps OK on planes, so he’ll be there to entertain everyone. 🙂

Hopefully I’ll feel fine tomorrow…

Just a word of warning to anyone trying to get hold of me in the next three days. From the hotel wifi I am unable to access Gmail or any social media. I’ve posted a couple of messages by connecting to my computer at work, but I’m not really going to be doing that too much. The great firewall of China strikes again… 🙂

Bjoern is able to access all this stuff from his phone, so I might use him as my secretary…

Cheers

Tim…

OTN APAC 2014 : Perth – Day 2

Day 2 started at 03:30 local time, so I got about 5-5.5 hours sleep. After doing a bit of work on the computer I went for a swim at the beach. I would like to say I was very brave and marched in, but I got to waist level and gave up. It wasn’t so much that the water was cold. It was more than the wind was so strong I was freezing to death before I got to the water. Bjoern and Connor were made of sterner stuff and stayed in. I wrapped myself in a bunch of towels and paddled. Once I was covered up I realised the water was not so bad, so I actually got back in. It wasn’t so much a swim, as jumping up and down trying not to get drowned by the waves. 🙂

The second day of the conference started for me with Connor‘s session on 12c for developers. It was a fast paced pass over a whole bunch of features that don’t necessarily make the headlines. There’s so much stuff in Oracle 12c I found myself thinking, I really need to write and article on that, only to remember I’ve already done it. It’s going to take a long time for this to become a natural part of my toolset.

Next up was Penny Cookson talking about the optimizer, focussing on the traps people fall into when they forget the optimizer sometimes has to make assumptions or guesses. Amongst other things, this included cases where histograms help and where they don’t. Where extended statistics help and where they don’t. Where cardinality (statistics) feedback helps and it doesn’t. Penny always uses a specific example or metaphor to explain her case. In this case is was OHarmonry (eHarmony in UK & USA) and all about finding the perfect man. Very amusing. 🙂

After lunch it was back-to-back sessions for me. I think they went OK, but I was very tired so it was really hard to get psyched up for them. A couple of times I felt like I was really straining to speak without slurring my words. I always say I am nervous before every talk. I was too tired to be nervous before these, which is not a good thing. It’s quite hard to be objective about your own performance. I felt kind-of hyper in yesterday’s sessions, which made today feel comparatively flat. I hope they didn’t come across that way. Four sessions and a 5 minute contribution to a keynote in two days while sleep deprived is not optimal, but you gotta get the job done. 🙂

After my sessions I went to watch Penny Cookson and Scott Wesley speaking about presentation skills. Every bit of advice you can get helps…

The last session of the day was Connor McDonald speaking about hardware options for Oracle DBAs. Over the years you come across a lot of information, but it’s really nice when someone breaks it down into really simple terms and puts it all together so you get hit with it in one go. It kind-of crystallises in your mind. As is normal for Connor, it was a fast paced session, which was what I needed for the last session of the day. If I had sat in a sedate session I would have fallen asleep…

After a quick wrap-up, we headed down to the bar and sat speaking to the AUSOUG and SAGE Computing Services folks. After that we popped out to get some food, then Connor gave Bjoern and myself a lift to the airport.

It’s now 00:30 local time as I write this and in about an hour we board a 5 hour flight for Singapore, then a 5 hour flight to Shanghai. I’m going to be a right mess by the time I get there! 🙂

Thanks to all the folks in Perth for inviting us along and making sure everything went smoothly. Thanks also to Connor for being our chauffeur. 🙂

Cheers

Tim…

OTN APAC 2014 : Perth – Day 1

I got up at 04:00 local time and spent the morning working through some stuff on the computer. Due to not reading tweets properly, I missed going for a morning swim at the beach with Bjoern and Connor.

Day 1 of the Perth conference started with some quick keynotes, then it was on to the first session. Inspired by the lightning talks at OOW, the first session I was involved in was a group of us each giving a 5 minute talk about impressions of this years Oracle OpenWorld. This one was less technical than the OOW sessions, but I thought it was fun.

After that I headed off to watch Chris Muir‘s talk about the data visualisation functionality in ADF. There is some pretty neat stuff in there these days! I think the important message from this was Oracle are not trying to make it all things for all people, but it should be pretty easy to use these visualisation gizmos for most of the stuff you need to do. There will always be a place for specialised visualisation tools. I think this is a good move on their part. Overcomplicating the offering would be a mistake IMHO. Even so, it’s darn impressive what this stuff can do these days! You can see some of the stuff that gets bundled with ADF 12.1.3 here.

After that I headed over to watch Bjoern Rost do a session on Flashback Data Archive. I had a quick chat with him and Connor about the subjects afterwards. I’ve not looked at the 12c enhancements yet, but it seems there is some interesting stuff there.

I spent quite a bit of time catching up with Chris Muir after Bjoern’s session, so I missed some other sessions. Then it was off to mine. I did back-to-back sessions on virtualisation and WebLogic. They are intentionally “light and fluffy” introductory sessions, so I hope they were useful to people. I got some questions at the end and talked to a couple of people afterwards, so I know there were at least some satisfied customers. 🙂

There was a social gathering to mark the end of the first day, then we headed back to the hotel and bed.

I’ve not been in this neck of the woods since 2011, but it feels like only yesterday. I kept bumping into family faces for a chat, which was really cool.

Tomorrow is going to be a long day. I’ve got the conference all day, with my two database sessions in the afternoon, then Bjoern and I have got to hang around until 02:00 in the morning to fly out to Shanghai. I’m looking forward to the conference, but not looking forward to the long wait before a long two-leg flight…

Cheers

Tim…

 

OTN APAC 2014 : The Journey to Perth

It was a pretty uneventful morning. I did my normal trick of checking everything was turned off, then checking again, just in case… 🙂

I breezed through baggage drop-off and security in record time, barely breaking stride.

We were a little late getting on the plane and stared taxiing out to the runway before everyone was seated. I don’t think I’ve ever seen that before. The first flight was somewhere between 6.5-7 hours long, followed by a 2+ hour stopover in Dubai. There was one minor incident when a woman had a hissy-fit at the stewardess, which resulted in her reporting the stewardess to the purser. A little while later, I went and found the purser and told her what I saw as a witness of the event. Basically, the stewardess was really nice and the passenger was being a stupid miserable old cow. Nuff said.

The second flight from Dubai to Perth was about 10.5 hours. No real dramas, and amazingly for me I actually got some sleep. I probably slept about 3 hours in total, made up of a few minutes here and there.

I arrived in Perth at about 17:45, having told folks here I would be arriving at about 14:00. I really don’t know what is wrong with me and travelling. 🙂 I got through passport control and customs with no worries, then got a taxi to the hotel. Once I was connected to the wifi I had to deal with nearly 2 days worth of emails in one go. It always amuses me how it feels like one long day for me, but 2 days for the rest of the world.

There was a dinner in the evening, but I was frazzled, so I ended up going to bed at about 22:00 local time and waking up this morning at 04:00. I’m supposed to be going out swimming in the sea this morning, but I’m hoping Connor and Bjoern are hungover and change their minds…

So the madness starts today. Wish me luck!

Cheers

Tim…

OTN APAC Tour 2014 : It’s Nearly Here!

airplane-flying-through-clouds-smallIn a little less than a week I start the OTN APAC Tour. This is where I’m going to be…

  • Perth, Australia : November 6-7
  • Shanghai, China : November 9
  • Tokyo, Japan : November 11-13
  • Beijing, China : November 14-15
  • Bangkok, Thailand : November 17
  • Auckland, New Zealand : November 19-21

Just looking at that list is scary. When I look at the flight schedule I feel positively nauseous. I think I’m in Bangkok for about 24 hours. It’s sleep, conference, fly. 🙂

After all these years you would think I would be used to it, but every time I plan a tour I go through the same sequence of events.

  • Someone asks me if I want to do the tour.
  • I say yes and agree to do all the dates.
  • They ask me if I am sure, because doing the whole tour is a bit stupid as it’s a killer and takes up a lot of time.
  • I say, no problem. It will be fine. I don’t like cherry-picking events as it makes me feel guilty, like I’m doing it for a holiday or something.
  • Everything is provisionally agreed.
  • I realise the magnitude of what I’ve agreed to and secretly hope I don’t get approval.
  • Approval comes through.
  • Mad panic for visas, flights and hotel bookings etc.
  • The tour starts and it’s madness for X number of days. On several occasions I will want to throw in the towel and get on a plane home, but someone else on the tour will provide sufficient counselling to keep me just on the right side of sane.
  • Tour finishes and although I’ve enjoyed it, I promise myself I will never do it again.

With less than a week to go, I booked the last of my hotels this morning, so you can tell what stage I’m at now… 🙂

I was reflecting on this last night and I think I know the reason I agree to these silly schedules. When I was a kid, only the “posh” kids did foreign holidays. You would come back from the summer break and people would talk about eating pasta on holiday and it seemed rather exotic. Somewhere in the back of my head I am still that kid and I don’t really believe any of these trips will ever happen, so I agree to anything. 🙂

Cheers

Tim…

 

 

Oracle OpenWorld 2014 : Summary

OpenWorld 2014 was dominated by jet lag. Not that “special” type of Doug Burns jet lag, but the real stuff. As I mentioned in a previous post, having been ill in the 3 weeks leading up to OpenWorld, the jet lag hit me hard and I had nothing in reserve to get me through it. I’m now back in the UK and it is even worse. It’s 01:00 as I write this and I’ve been to sleep for about 3 hours. I’m now wide awake. It’s going to be a long day!

Apart from the jet lag, what was the overall message at OOW14?

Cloud

This one was pretty predictable. What broke away from the message of previous years was the Infrastructure as a Service (IaaS) message. In previous years Oracle said they were not interested in IaaS as competing with the general cloud providers, like AWS, was not good business. As Mark Rittman put it, this is “a race to for the bottom”. Instead, Oracle wanted to focus on the Platform as a Service (PaaS) and Software as a Service (SaaS), where they are selling their technology stack and software respectively. This has much better margins and allows them to do something that other cloud providers can’t really compete with in a price fight.

In reality any PaaS provider needs to also provide IaaS because applications do not work in isolation. It may be nice to have your Oracle database on the cloud, but what do you do with that 3rd party application that you would like to run in the same data centre as the database?

Oracle have come out with a statement that they will provide general purpose compute power and not be beaten on price by the likes of AWS. That sounds quite scary, but I think the reality is this will only be a small part of their cloud business. I would imagine most people moving to the Oracle Cloud will be doing so for the PaaS and SaaS offerings. The IaaS will only play a supporting role.

In more general terms, Oracle are planning on adding just about everything “as a Service” on their cloud. They’ve announced Database Backup, Documents, Big Data (Hadoop) and Node.js as a Service, which were new to me, along with all the usual stuff we either already had or expected…

Once everything is available, it will certainly make an impressive lists. From a platform perspective, not quite as diverse as AWS yet, but impressive none the less.

Big Data

On the whole, Oracle shied away from the normal, “You can do big data with the Oracle database!”, message they’ve been trying to promote over recent years. I think the world and their dog understand that “Big Data” and relational databases don’t really go hand-in-hand.

Instead, Oracle were pushing the Oracle Big Data SQL product. I started off pretty cynical about this, thinking it would just be a knock-off of Cloudera Impala, but it does seem to be something more. Big Data SQL allows you to create external tables over Hadoop and NoSQL data stores, so you can write SQL against them and process the data in your Oracle database. No need to learn any new query/programming tool. It also allows you to join differing data sources together.

Regardless of your views on big data, there are a lot of “data people” out there with SQL skills and, relatively speaking, nobody with map reduce skills. That and the fact that many companies for the foreseeable future will be churning through their map reduce jobs to produce data to put into a relational database for reporting, means that integration between Hadoop, NoSQL and RDBMS will be a key component. Oracle Big Data SQL seems to have hit this nail square on the head. If it weren’t so ridiculously expensive, it would be interesting to see the adoption rate!

JSON Support

This might seem like a minor feature on the surface, but I think it is a massive step forward for Oracle. The reality of the marketplace is that document stores are now seen as the preferred solution for some situations. Oracle will never compete with the likes of MongoDB (it’s webscale) on shear performance, but how many people really need to hit those numbers? Last year my company were considering MongoDB/RavenDB for some HR projects. The main factor against this idea was the split of the “single point of truth” between Oracle and another database technology. If the JSON support in the Oracle database had been available, we would probably have used it.

The JSON support in the database seems pretty comprehensive to me. Once the REST APIs are available, through Oracle REST Data Services (ORDS) it will be interesting to see how the developers react to this.

APEX 5.0

It was rather disappointing to hear that APEX 5.0 is a long way off going to production. The logic for holding back is sound. It’s got to be bullet proof, especially the upgrade process, so it’s better to wait until it is sorted, than release early and get lost in a support nightmare. Even so, I wanted the pretties… 🙂

WebLogic

I didn’t listen to the formal announcements about WebLogic, so I’m not sure how much of what I heard is still under NDA from ACE Director Briefing. For that reason, I’ll keep my mouth shut, but suffice to say, there are things in the pipeline that will make my life much easier!

Database

The database side of things was relatively quiet. Two years ago we got, “This is what we will give you in 12c”. Last year we got, “This is what we have given you in 12c”. This year we got, “This is what we gave you last year in 12c”. 🙂 We did of course get lots of In-Memory stuff, but we knew about that last year and it is now GA… 🙂

I guess some news was that we are 18-24 months away from 12cR2, so you will probably have to upgrade to 12cR1 if you want to retain support without paying any extra cash. The proposed release date for 12cR2 will be after the free 1 year extension to support runs out… When you consider the obligatory, “wait for the first patchset”, that could be a long time without support… (Doc ID 742060.1)

Everything Else

There were of course numerous things about Oracle Linux, Oracle VM, MySQL 5.7, Engineered Systems and a whole bunch of other stuff, but I guess if you follow those areas you already know…

Overall

As mentioned in a previous post, the take home message for me is that Oracle are working hard to be a cloud provider. As such, they have spotted obvious flaws in their own products. A big proportion of the new features in their infrastructure products seem to me like a direct result of them “eating their own dog food” while trying to become a cloud provider. I think this is good news for the future of Oracle products, even if you don’t care about the Oracle Cloud specifically.

Big thanks to the ACE Program and OTN for getting me to OOW14. It was great to meet up with my Oracle friends and Oracle family again. I’m looking forward to a jet lag free 10th anniversary OOW next year! 🙂

Cheers

Tim…

Oracle OpenWorld 2014 : ACE Director Briefing – Day 2

Day 2 of the ACE Director Briefing followed a similar format to day 1. Lots of things we are not allowed to talk about and a few things we can.

Of the things we can talk about:

  • The release schedule for 12cR2 (12.2) was mentioned. It was published a few weeks ago. It’s tentatively listed as 1HCY2016. You can read it for yourself in MOS Note 742060.1.
  • Dan Mcclary‘s session on Oracle Big Data SQL seemed to win over even the most cynical in the room. It was a really interesting session on something I know virtually nothing about. 🙂 Having external tables pointing to Hive and NoSQL sources, allowing SQL queries and joins across multiple data stores is pretty cool.
  • The JSON support in 12.1.0.2 looks pretty cool.  Some more goodies related to APIs for this functionality are on their way in Oracle REST Data Services (APEX Listener).
  • David Peake previewed Live SQL. It’s still under construction at the moment, but it looks like it’s going to be a useful resource for people learning SQL or sharing examples with each other. Kind-of like SQL Fiddle on steroids, with an emphasis on learning through tutorials and example code etc. The aim being to reduce the barrier to entry.
  • Wim Coekaerts gave an overview of what’s going on in the Linux and virtualization world. I’m a total fanboy, so I loved it. 🙂
  • Steven Feuerstein spoke about his new initiative to revitalise the SQL and PL/SQL communities in Oracle. It’s still in the early stages, but it will be interesting to see how this develops. Obviously I have a vested interest in anything that makes the database look cool! 🙂

Of the things we can’t talk about:

  • We can’t take about them. 🙂

Overall I thought this was a really great briefing. There was a lot of stuff on the agenda that didn’t relate to my core skill set, but I still got drawn in. It’s good to be aware of what’s happening around you, even if you will never get chance to get on top of it. Big thanks to the Oracle ACE Program and OTN for getting this organised for us!

After a bit of socialising, it was on to the coach to drive from Redwood Shores to San Francisco. We are now all in the Hilton and waiting for OOW to start tomorrow.

This morning I did my first proper gym visit of the trip. I hit the weights and did some stretching. I’ve just got to avoid food for the next 6 months and I’ll be buff! 🙂

Cheers

Tim…

OTN APAC Tour 2014

As well as losing the ACED OpenWorld confirmation email, it turns out my website/mailbox move also caused me to lose the email about being accepted on the OTN APAC Tour 2014. I saw a tweet this morning saying that I was on the agenda for the NZOUG event and checked with Francisco to see what was going on. That’s when I found out that yet another important email had gone missing… 🙂

The good news is I had already agreed the time off work, so everything is good for the tour.

  • Perth, Australia : November 6-7
  • Shanghai, China : November 9
  • Tokyo, Japan : November 11-13
  • Beijing, China : November 14-15
  • Bangkok, Thailand : November 17
  • Auckland, New Zealand : November 19-21

After the OTN Yathra Tour 2014, which was 7 cities in 14 days, I told myself I was too old to do all this tour stuff… So much for that idea… 🙂

Although it’s a 6 event tour, the first and last events are pretty much like being at home for me. I’ve been to the AUSOUG and NZOUG events a few times, so it will be good to meet up with everyone again… It will be my second time in Beijing, and I’ve seen the traffic in India now, so I’m hoping I will cope better with the roads in China this time. 🙂 Shanghai, Tokyo and Bangkok are all new to me, so it will be interesting to see how I cope with them…

As always before one of these tours, I am a complete mix of excitement, fear and general panic! 🙂

I look forward to seeing you all there!

Cheers

Tim…

2014 OTN MENA Tour

Just a quick shout out to the 2014 OTN MENA Tour, which starts in a few days. The events are:

  • Bizerte, Tunisia, 26th May
  • Béja, Tunisia, 27th May
  • Riyadh, Kingdom of Saudi Arabia, 29th May
  • Jeddah, Kingdom of Saudi Arabia, 31st May
  • Dubai, United Arab Emirates, 1st June

This is the first time this tour is happening, so please show your support and register.

Good luck to all the folks who are taking part. Unfortunately I can’t be there, but I hope to take part in a future event…

Cheers

Tim…