I was feeling really, really tired towards the end of day today, It’s hard work being at OpenWorld, despite what some people back home might think!
Thanks to Doug Burns’ advert the day for me started with Johnathan Lewis’ “How to be an Expert”. I think I might still be a couple of hundred years of top-cutting off that still, but it was a very funny anecdote filled presentation, though it was sometimes hard to hear due to the background noise – the unconference rooms are more like fenced off areas than real rooms.
Jonathan was claiming that the database has not changed architecturally from version 6.0. Also posed the question if you change 1 byte of data in a row, how much redo is generated. It’s a surprisingly large amount. His point was that if you don’t know, how can you spot if something is anomalous, or if you do spot that, how do you know where to look for the cause of the problem. It was also interesting hearing Jonathan saying that he rarely uses anything more than statspack, execution plans and some v$ views. Not using 10053 as a first tool, only if he suspects an optimizer bug.
After picking some swag from the OTN lounge and saying hello to a besuited Alex Gorbachev I headed to “introduction to OBIEE”. The Oracle presenters gave a general overview of the toolset which was useful enough for me, but I’m afraid the University at Buffalo guy maybe gave a bit too much detail on his own reports, showing screen after screen of blurred out live reports.
Next up was:
High Availability Vison: What’s new in 11gR2 – Juan Loaiza
This was billed as what is new in 11gR2 but, I’m afraid a some of slides did seem quite familiar. It was a high level overview of various new features that you can utilise for increasing the availability of your systems.
Couple of things that stood out for me. I finally think I understand the concept behind RAC one node. Juan was explaining it in terms of being able to perform rolling patches, or rolling OS migrations – he made the comparison with virtualisation where you can seamlessly migrate a VM from one host to another, well this is migrating an oracle instance from one node to another, which in some ways gives you more flexibility than virtualisation because you can change things like the OS version while you move.
Next was quite a strong statement upon the GoldenGate acquisition. In very red letters Juan stated quite categorically that:
GoldenGate is Oracle’s Strategic replication solution
He was quick to add that streams replication continues to be supported as an Oracle database feature, but the best of streams technology will be intergrated into GoldenGate.
Ended up missing out on lunch, so note to self it may say 12:00-14:30 for lunch, but make sure you go early they seemed to close up way before the advertised time. After (non)-lunch I went to a bit of a disappointment presentation on active-active DR:
True Active/Active Configurations with Oracle Active Data Guard – Aris Prassinos,
I think the presenter actually had a really good story to tell, but I’m afraid he really did not present his message well. You could see people leaving in droves, which is a shame. Also he finished after about 25 minutes (of an hour session). He was using active dataguard with BIG-IP’s to send read-only queries to the standby location, while routing read-write to the primary. He was also using a method to detect when a standby is too far behind so you don’t send queries to stale data – I think 11gR2 can do this for you a bit easier. This is an architecture I’ve been planning on using for a little while now, but the style of the presentation kind of made it less interesting.
After this I was squashed into
Interpreting Execution Plans – Chris Antognini
This room was a total nightmare for about 1/3 of the audience. The projector screen was on the far right side of a very wide but shallow room. Sadly I was in the obscured 1/3. However, this talk was based on Chapter 6 of his book, and I’d seen most of this stuff at UKOUG last december.
I’ve already blogged about the final presentation I attended on Edition Based Redefinition.
Like many I also seem to be struggling with jet lag, I had thought staying up later, and later would mean I’d start sleeping later and later, but I can’t seem to stay asleep past 04:00am. I expect to be shattered by the end of today.