Oracle OpenWorld – Monday

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.


3 thoughts on “Oracle OpenWorld – Monday

  1. Hi Jason, I still think you are having loads of fun, despite the hard work.

    Nice to hear that Jonathan also use the simple tools: Statspack, Vee-dollars and some traces only if needed. No fancy stuff, just good, systematic thinking.

    On using Active-DG for queries: I guess you will have to do the work, and the ppt on that yourself then eh ? (didnt you try that yourself a few years back?). I’ll come listen.

    Goldengate is a logical choice: it seemed to be way ahead of streams, and now it is an Oracle Product. I hope they keep it robust and simple when they incorporate it into OEM/GC/GUI point-n-click stuff.

    Keep having Fun!

  2. Hi Jason

    > This room was a total nightmare for about 1/3 of the audience.

    Yeap. It’s really incredible that they setup the room in that way. In addition, since the session was fully booked since about one week, they new in advance that there would be a problem. So, they simply decided to ignore that a problem existed. What a pity!


    • Hi Chris,

      And to cap it off, I’ve seen quite a few presentations by Oracle employees in some of the larger rooms that are pretty deserted. Looks like someone from Oracle was not paying attention!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s