Wait? Stop 0? How does that work? One reason may be that there is a lack of a universal understanding of what to call the first element of a finite set. Like floors in a building. Things you learn on tours like these are that 1 is not actually the ground floor in all countries (and it was the reason why I exited the lift on the wrong one). But the real reason that Singapore was stop 0 for me is that it is not actually part of the OTN tour (but in my opinion should be next year). I had planned a quick 3 day stopover and stay with Doug Burns and he decided this was a good time to start a local oracle thing in Singapore. So with less than a week notice he booked a room, organized food and drinks and managed to get over 30 people to show up (Hemant Chitale helped spreading the news) for the first installment of #SOS Singapore Oracle Sessions. Excellent! Portrix, Oracle and Doug chipped in as sponsors for the few expenses we had.
The speakers were blown away by the enthusiasm and passion of the attendees, received many great questions and chatted in the breaks. There was also great networking between people and everybody seemed to at least remotely know everybody else or made introductions. It was very clear that there was a demand for something like this format and while people were unsure if they needed a “proper” user group it was evident that everybody would like to see this continue.
I started by talking about SQL Plan Management. I have done this talk a few times now and am really happy to see how I am making progress with it. I was happy to make the most important points very clear, answered a few great questions and still finished ahead of time because Doug was signalling from the back of the room that the pizza was getting cold.
Doug talked about SQL Monitor (one of the most useful performance tools in Oracle) and how to use it from the commandline. What I did not know was that you could create just the same flash based report that the full-blown Cloud Control is generating and even more. Some of the tabs are grayed out in certain version of EM12c but they work in the CLI-generated one.
Morton did a Big Data primer, introducing people to what big data is and what it is not, giving funny but concise quotes from the Oak Table mailing list, giving an introduction to Hadoop and what the hadoop connector in Oracle can do for you (mostly access files on HDFS so you can either export big tables straight to hdfs for mapreduce processing and/or to import the results of a map/reduce job which will be written to HDFS). He finished with some funny correlation-type analysis which actually helped a customer identifying how to better do their job and got them to invest into big data infrastructure.
The only bad thing I can say about the Sessions was that it cost me a few hours of precious sight-seeing time in Singapore. People have told me to come for a while but I never thought it would be as exciting, interesting and cool as it actually was. I wonder why we “dream” about some destinations (some of which turn out to not even be that great once you are there) and turn down the idea of visiting some others. Lesson learned: keep an open mind and good things will happen to you. To everybody else: Singapore is well worth a visit, with or withour Oracle Sessions.
The picture on the left was taken from the bathroom of a hawker centre (street food court). There was no wall behind the sinks, only the awesome view of tropical plants, supertrees and the iconic Marina Bay Sands hotel.
As I am writing this I am already in Perth for the annual Western Australia Oracle UG conference enjoying a rare moment of peace and quiet before the conference tomorrow. I have already experienced a new world and images of tropical plants, buildings old and new and exotic smells (both good and bad) fill my mind but this is merely the start of a tour that lasts two more weeks.
PS1: #SOS is a really bad hashtag
PS2: B-Tree indexes would be awesome if they were called Supertree-Indexes