Then a thought occurred to me. While he was here, why not setup an informal Oracle users meetup, much like the various ones at cities around the world like Sydney, Birmingham and London (to name but three I'm aware of). Morten Egan, my new colleague and Oak Table luminary had already suggested to me months ago that we should get something going in Singapore, so why not start now?
Well, in a matter of a few days, we've put together an agenda, a room, we will be having pizza and beer and other drinks and three hopefully useful sessions from experienced speakers.
Here is the agenda (SingaporeOracleSessions.pdf) and a map (SOSMap.pdf) to help you get to the venue which is very handily placed near Bugis MRT. All that's required to register is to email me at dougburns at Yahoo. There are currently 21 people registered but the room holds (believe it or not) 42, so spread the word!
Hopefully, it's just the beginning ....
Oct 8: OOW 2014: Day 2
I picked up a few extremely useful things from this presentation but I think the most important one was the journaling area used when rows in the standard row-orientated buffer cache have been updated. Which, for starters, means that only 80% of the allocated memory will be available for your original data. Not a problem, but worth knowing.
What really jumped out at me though was when he discussed how the number of updated rows could affect the optimiser's decision to use In-Memory or not. I might not have explained that very well, but I believe the effect would be that the optimiser is likely to flip between using In-Memory or not depending on quite a few variables. Which means one thing to me. Potential Execution Plan instability. I'm not sure how Oracle could get around this because cost-based decisions are the sensible approach but I foresee lots of new performance analysis and tuning opportunities! Not quite "flick a switch and it just works", but who would ever believe that kind of thing anyway?
Great presentation, though. Exactly what Oak Table World is all about so thanks to Kyle Hailey and the various sponsors () and speakers for making it happen!
Judge for yourself. No need to go to San Francisco!
... or how about finding open_cursors set to 2000? A per-session limit of 2000 cursors? As Graham pointed out - good luck keeping track of the state of all of those! As soon as you stop and think about these things sensibly, you realise that it's almost certainly a sign of an application leaking cursors.
There were lots of similar examples but the interesting overall approach that I would say they were illustrating is something that I tend to do when I first arrive at a new client site and I've watched other experienced Oracle techies do the same.
An AWR report is not just the top 5 timed events and the sections at the top are a pretty good description of the actual system workload which, in turn, can tell you a lot about the application design. Then, based on potential application design issues, you can drill down into the report and look at later sections to see where all those leaked cursors or transaction rollbacks or (whatever) ... are coming from.
Updated Later: As Toon Koppelaars highlighted on Twitter later, you can see this version of exactly what I'm talking about here, for free. I should hang my head in shame because Andrew and Graham made a point of all the RWP videos being available online here. Watch and enjoy!
Lucky boy that I am, I was able to retire to the comforting surroundings of the Thirsty Bear to continue the conversation about all things performance related with Graham and JB, much of the conversation being me whining about why people don't use the *full* range of tools that come with the Diagnostics and Tuning Packs that they've paid Oracle good money for. That's why I've been slowly developing a presentation on that very subject.
Then it was back to Oak Table World to catch Greg Rahn talking about all that Hadoop stuff *again*! Even though I only caught part of the presentation, I do keep managing to pick up bits and pieces on the subject although I wonder when it'll become relevant to my day to day work. Probably whenever I'm too late to the party, as usual
But my main reason for showing up was to see Kevin Closson talking about using SLOB in some less obvious ways. Because SLOB is a good all-round Oracle workload generator, it shouldn't be seen as simply a tool for testing storage performance and that's probably it's main strength. Kevin is always a great speaker and I find listening to him a very different experience to reading his blog, but I'm not sure I can put my finger on why. Oh, he also had the most ridiculously bright SLOB buttons! (As I found out by making the mistake of looking to closely at it as I tried to switch it on )
At some point, all of the slides for the Oak Table World presentations should be available on the site, so keep a look out for those! (Oh, and I got my T-shirt which is deeply cool and was one of the few items of non-ACE swag I managed to pick up all week)
From there on, it was more or less party all the way.
- First quiet beers and snacks with lots of Oak Table and Oracle types.
- Then my very first ever Customer event that wasn't for a specific technology area, but a sales region. Man, *that* was a mistake! Suits *everywhere*! but I suppose it was useful to build contacts with the senior support managers in my new region.
- Instead, I headed towards the OTN night in Howard Street (until I realised I'd just dropped my bag with the entry ticket back at my hotel room)
- So instead I landed at one of the events of this and any other OOW - The Friends of Pythian Party'. As always, beautifully-organised, very generous on the liquid refreshments and the coolest crowd in town. Just because I find myself thanking Vanessa Simmons, Paul Vallee and all of the Pythian crew every year doesn't make it any less sincere.
I have to be honest, though, and say that the highlight of the night for me was spending much more time with Kevin's punchy, beautiful and fun wife Lori. If you think Kevin's smart, wait until you meet his wife! There's a lady who can hold her own and make me chuckle Problem is that I think she's used to scaring people but us Scots don't scare so easily
It was a great night anyway, as always, and although this is entirely unconnected to the Pythian party but might have had a *lot* to do with jet lag, I didn't wake up until 11:45 the next morning
Oct 5: OOW 2014: Day 1
From left-to-right : Karl Arao, Martin Bach, Kerry Osborne, Andy Colvin, Tanel Poder and Frits Hoogland.
They talked a little about the original version of the book (largely based on V2) and how far Exadata had come since then, but it was a pretty open session with questions shooting around all over the place and great fun. Nice way for me to wrap up my user group conference activities for the day and head out into the sun for Larry's Opening Keynote.
Sep 28: OOW 2014: ACE Director Briefing
Disclosure: I'm attending Openworld at the invitation of the OTN ACE Director program who are paying for my flights, hotel and conference fee. My employer has helpfully let me attend on work time, as well as sending other team mates because they recognise the educational value of attending. Despite that, all of the opinions expressed in these posts are, as usual, all my own.
The first day of the ACE D briefing was a bit of a wipe-out for me as I had so much catching up on bits and pieces of work and personal email to do, having arrived very late the previous night, although I still managed to spend some valuable time catching up with friends of the Oak and non-Oak variety as well as hearing some useful info from various Product Managers. I was gutted to have missed Thomas Kurian's briefing session because, as I heard later, it was as splendid as usual. I think some of the enjoyment comes from people's fascination with how on top of things he is, talking at all sorts of technical and non-technical levels over a very wide portfolio. That's pretty much how I remember the last few briefings.
Despite the inevitable arrival of jet lag screwing up my sleep, I've been able to enjoy day two much more (once I'd absorbed some light-hearted wind-ups about my disappearing act). Today was always going to be the most enjoyable for me anyway as the agenda was more database-centric.
It kicked off with a session on the current state of play of MySQL which I must admit I've almost forgotten about (conspiracy theorists will enjoy that) but seems to be ticking along quite nicely with incremental performance and functionality improvements although the presenters were keen to point out that MySQLs forte is not it's functionality so much as it's ubiquity in the web area, given it's part of the LAMP stack. Like a lot of the presentations, it might not have been about something I use day to day but was very enjoyable keeping in touch with other technologies.
Next was an informal conversation with Bob Evans, the Chief Communications Officer, which covered a wide variety of subjects with the usual direct and critical approach I've come to expect from the ACE Directors in attendance (you might be surprised!), raising concerns about the interface between Oracle Sales and their shared customers. I was disappointed to hear that there seems to be a pattern of scheduling local sales events at the same time as Oracle ACE tour events. Seems pretty daft to me. (Another one for the conspiracy theorists, I suppose.)
Then Gene Eun gave us an update on the Oracle Database Cloud Service. Although I still feel Oracle are way behind the curve on this, I don't think that necessarily means they can't make up ground, as they have in the past, but I think the most important message for me was a reinforcement of an answer to a question I asked last year. There's no reason why people can't use the same technology to run their own on-premise cloud and, working in Finance as I seem to have done for a while, the most realistic implementations I can imagine are hybrids of onsite and offsite infrastructure to cope with regulatory requirements whilst still gaining the benefits of offsite deployment where that makes most sense.
I didn't spend so much time drinking coffee in the Oracle canteens this year, but I did manage to have an enjoyable catch-up with Uri Shaft, a true development geek who always has interesting thoughts both on those technologies he is or has been involved with, but also other development areas that he has nothing to do with! Never a man short on opinions on software and a truly nice guy. Sadly, the regular JB catch-up no longer exists and that Maria Colgan moves in entirely different circles these days! (That would be a joke, folks, and I'm looking forward to light refreshments and chat when she's in Singapore soon.)
Speaking of Maria, she was part of the presentation team for the two hour Oracle Database Development Update, which is one of the key sessions for most attendees. Penny Avril and Maria Colgan kicked off with an all-too-short session discussing release plans and a little about In-Memory Option but I was left with the feeling that, having put so much work into getting the In-Memory stuff ready, it's now a case of consolidating the work and delivering product. i.e. I didn't notice any earth-shattering announcements in the database area but I suppose last year made up for that!
So most of the session was focused on two non-RDBMS areas. George Lumpkin on documents in the database and JSON stuff which was one of those - interesting but not something I'm likely to work with for a while presentations.
Dan McLary was almost certainly the speaker of the day as he delved into Oracle's BigData/Hadoop offering in good detail but with passion and a refreshing honesty about where Oracle fit into this field which still managed to be very positive about where Oracle are taking it. As he pointed out, the combination of being able to query anywhere (different data sources and technologies) with the functional richness of Oracle's SQL implementation is likely to be a pretty compelling offering.
It was an afternoon full of good presenters likely to keep the jet-lagged awake (although both Connor McDonald and I were struggling badly by this stage) like David Peake who covered Apex and a new website - Learning SQL - to help people, erm, learn SQL. I think we'll be hearing more about this in the upcoming week.
Wim Coekaerts is always popular with a small chunk of the ACED crowd and was again with his usual Linux and VM update, an informal conversation delivered without notes or slides which hit mainly on the areas that the attendees wanted to discuss. In a neat piece of agenda symmetry, he pointed out the presence of DTrace probes for MySQL running on OEL, as he discussed in his recent blog post.
By now we were running late and beers were beckoning, so Steve Feuerstein did a great job of just about keeping people going with his discussion of Oracle's attempts to reengage and energise the traditional Oracle SQL and PL/SQL technologies we know and love with a new (and quite possibly younger!) audience - YesSQL! Keep an eye out for what is likely to be a fun and different session with Steven and Tom Kyte and other special guests at 18:30 on Monday in Moscone South 103.
... and with that all wrapped up, it was time for beers and the bus into the city. The hotel check-in wasn't the car crash it usually is, but by the time it was all done and dusted there was just time for a few more drinks and since then it has been sleep, sleep, sleep for me
The usual thanks to the OTN team for putting together a varied and interesting briefing, which must be a really tough task when the Dev folks are all up to their eyebrows preparing for next week. Great work!
I'm hoping just an hour or two more and I'll be bright and breezy for Sunday, the first proper conference day. With my apparently new-found energy and dashing good looks (courtesy of Singapore), I'm expecting the week to be a good one!
Sep 25: Singapore
Now, *this* is a post I should have written ages ago but somehow (as in most cases these days) Twitter overtook blogging because it is so much easier to write a bunch of tweets on a mobile device of some kind when living normal life than to sit down and write a blog post.
By now, most people I know know that I've moved to Singapore because I've either bombarded them with face-to-face chat leading up to the move, or they've similarly but asynchronously been bombarded by my 140-character diarrhea on Twitter. (If you care about that, I'm trying to do it from @DouglasIBurns.) But, to spare friends who have not had the joys of either experience who I might be seeing for the first time in a while at Openworld, here are a few facts that might make conversations a little less painful ....
- I now live and work in Singapore.
- It's my first job as an employee of a company other than my own for around 22 years. Those who know me well will understand that this fact is the most surprising and scary of all!
- Singapore is fantastic and don't believe a large majority of what you read about it on the Internet. There's usually some truth in there but it's exaggerated, both positively and negatively. If you're expecting some kind of pristine, well-oiled, boring Utopia, then you've got the wrong place. There are definitely elements of that, but I've been smoking my little head off whilst having a relatively cheap cold Tiger beer in less-than-salubrious surroundings. It might be slick and sterile by Asian standards, but it's lively and real enough for me.
- I have DBA privileges back for the first time in a long time and I'm enjoying that immensely. A senior role that gives me scope to actually *do stuff* is more than fine by me!
- I think our original intention in moving was to give it a try for the minimum 1 year that would be required, but probably 2. However, I keep running into people who thought the same and are here 4, 6 or 8 years later. I can understand why.
- Little known fact: I moved to Singapore when I was around 9 months old because my dad was posted here by the Royal Air Force, just as Singapore was becoming an independent country, and left when I was almost 4. So I grew up in Singapore, but remember nothing about it. However, my older family adored it and they're all looking forward to coming back to visit. I still haven't visited our old home yet. I wonder if it will provoke any memories? As my eldest sister pointed out, I celebrated my first birthday in Singapore and (hopefully) I'll celebrate my 50th one here too.
- Despite the move requiring a lot of effort, I feel re-energised by the place and so hopefully I can get back to more blogging again, particularly as I've had 3 months of interesting issues to contend with, although there will be limits on what I can blog about unless I can reproduce some non-specific test cases
- I am *so* pleased that Morten Egan decided to come here too. He's not only a stellar worker, but a pretty top human being too and it's good to have someone around with similar humour and sensibilities. We'll conquer the world together! (actually, that last bit may be a joke)
It's safe to say that it was a great decision to move and thanks to @madsjt and @RCT_Enterprises for taking it on with me! Other than that, no more Singapore chat here. Follow this Twitter account if you care.