Pythian Group

This blog post covers day 0 of UKOUG 2011 — Sunday, 4th of December, 2011.

Since there were so many of us from Pythian at the conference, I’m adding my name in the blog post title. I think I will be doing it for all conference posts as I think I’ve been doing for some time. This year, there were ten Pythian folks attending UKOUG Conference and we did twelve sessions including multiple presentations, masterclass, RAC Attack workshop, round-table and 10 minutes OakTalk. I think it’s the record number of session Pythian folks did at a single UKOUG conference and the record number of Pythian peeps attending. A dozen of Pythian people in Europe and now even a sales guy in the UK mean that Pythian penetration in the UK database services business is close to the infliction point. This is ultimately a good news!

Most of Canadian Pythian representatives arrived on Sunday morning to London Heathrow. The flight was quite empty so some of us managed to get a good nap in comfort of three empty seats. Since AirCanada has power outlets in most long haul flights, I was planning to work on my slides all the way in as I usually do. However, this time I was sitting next to Christo and he kept me involved in the conversation and at some point I was getting sleepy and finally took a nap as well so I’ve done literally nothing on my slides. Oh well, at least I had some rest and it was good because I was up for almost 20 hours after we landed except a quick nap in the car from London Heathrow to Birmingham. By the way, if you travel two or more from Heathrow, hiring car transfer service makes more financial sense than train or coach and is also quite convenient.
Read the rest of this entry . . .

For the final day of UKOUG there are quite a few Pythian presentations. Unfortunately a lot of them happen at the same time, so it won’t be possible to attend them all live.

Using Oracle GoldenGate to Minimize Database Upgrade Risk

10:10, Media Suite
Marc Fielding

Even the best-planned database upgrades can leave nagging questions: what happens if my upgraded system performs unexpectedly? Is there a way I can go back to the previous version without downtime and data loss? Oracle GoldenGate allows DBAs to give affirmative answers to these questions. Drawing on upgrade experiences ranging from mid-sized databases to a large 10TB 90-CPU OLTP system, this session will show how to optimally configure Oracle GoldenGate, minimize downtime, maximize replication performance, and integrate Oracle GoldenGate into existing infrastructure such as Oracle ASM and storage-based replication.

Learn the various deployment scenarios where GoldenGate can minimize upgrade risk and delivery business value. Find out how GoldenGate can help not only during the upgrade, but after the upgrade as well. Learn how to use GoldenGate in medium- and high-volume environments. See real-world, tested GoldenGate configurations. Find out lessons learned and pitfalls to avoid.

The Answer to Free Memory Swap and Everything

10:10, Hall 8A
Christo Kutrovsky

Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in detail the different types of memory, how to monitor memory, and how to optimally use it with Oracle. Multiple examples in the presentation demonstrate how certain actions on the database side cause different memory areas to be allocated and used on the OS side. Key underlying differences in operating systems approaches to managing memory will be highlighted, with special attention given to Linux and Solaris. Using Linux as an example throughout, this presentation explains how to effectively use tools such as “top”, “vmstat” and “/proc/meminfo” to look into into a system’s allocation and use of memory.

Amazon RDS, EC2 and S3 for Oracle Databases

11:20am, Hall 10B
Alex Gorbachev

This technical session focuses on specific recommendations and guidelines for leveraging the Amazon Web Services platform to host Oracle databases. We will looks into traditional database hosting using EC2 platform as well as recently introduced Amazon RDS on Oracle. We will look into how to configure, provision, backup, restore, monitor, and secure your databases in AWS. We will also look on how you can leverage S3 cloud storage for hybrid cloud deployments, particularly for backup and archival storage.

Backup and Recovery Roundtable

11:20am, Roundtable Area
Michael Abbey

A discussion of backup and recovery technology, problems and solutions. We will poll the attendees for an agenda on the day and proceed with an informal discussion not limited to:

RMAN, OSB, Sans, Data Guard backups, RAC backups and other topics of interest.

Concurrent Processing Performance Analysis for Apps DBAs

2:25pm, Hall 10B
Maris Elsins

Concurrent processing is one of the key elements of Oracle E-Business Suite, that’s used by most of modules for scheduling and processing background jobs. Keeping this functionality healthy is important to get maximum performance out of it. The paper describes the key metrics to estimate the performance of the concurrent managers, discusses approaches and techniques that can be used to understand how well the concurrent processing is set up, what are the bottlenecks and delays in processing of concurrent requests and provides tips on how to deal with each of the identified problem. This paper is targeted for Oracle Applications DBAs and technical consultants.

On tap for Tuesday is a 2-hour master class from Michael Abbey, along with an all-day drop-in RAC attack workshop with Alex Gorbachev and the RAC SIG.

Read the rest of this entry . . .

Another December has started and you know what it means right? It’s the Christmas time? NO! It’s time for UKOUG Technology and e-Business Suite 2011 conference! There are not many things that can make a passionate Apps DBA more excited than that. UKOUG Tech & eBS conferences are the only ones in Europe that have such a rich content for Application DBAs and this year it will not be different. Read the rest of this entry . . .

For those of you attending UKOUG today, there is a healthy dose of Pythian presentations on tap this afternoon. Actually, you can do it wall to wall 2:30pm to 6:30pm if you like.

To note:
Read the rest of this entry . . .

(editor’s note: the author is talking about UKOUG, the UK’s major Oracle conference, happening this week in Birmingham)

And so it should be :). The flight over was uneventful, save for my excitement about having 3 seats to myself. Then the big challenge surfaced … a 5’8″ human trying to recline in a 4’10″ horizontal surface. I woke about a bit later with a stiff neck but the shut-eye was worth it.
Read the rest of this entry . . .

My good friend (and personal hero) Cary Millsap is doing a series of one day classes around the world — Mastering Oracle Trace Data. One of them is conveniently scheduled in Birmingham Thursday next week right after the UKOUG Conference.
Read the rest of this entry . . .

Right now I’m sitting in the speaker lounge with Jeremy Schneider after hacking some RAC ASM stuff as a follow up to my last presentation. We were testing some failure scenarios but that’s a topic for another blog post.

Dan Fink cheated with his tiny blog post which was more like a twitt-long (and so did Christo.) so I thought to write something properly.

Monday started early for me — 6am. Quick run through my demos again and early breakfast. Registered before 8am while it was still empty and then joined Tom Kyte in the speaker lounge. We both had our sessions starting at 9am but Tom is a Pro when it comes to presenting — while I was taking the last minutes to go through my slides and do minor adjustments, Tom was calmly replying AskTom questions. Oh well, such is life.

My 2 hours presentation was a little slow and I wish the audience was a little more engaging but maybe it was just because all the locals hit the hibernate mode following “extreme” cold weather and didn’t quite wake up after the weekend (of course, there is not chance that it was bad presentation material or speaker…. no, no!). This was the same presentation as I’ve done at the OpenWorld but I included demonstrations of 11gR2 Grid Infrastructure and that was the tricky bit. In the end, everything pretty much worked with one small surprise. My last demo was troubleshooting of startup and I decided that I will screw up 3 things and troubleshoot online *first* time. I.e. I decided deliberately not to practice it. The latter wasn’t very smart as I had less then 10 minutes left. After few minutes of shame I had to move this demo in the list of homework. :) The good news, that I did go through my last slides briefly and I wanted to be brief there as Frits Hoogland was covering this area in more details later that day in his own session.
Read the rest of this entry . . .

Blogging from the Speaker Ready room which is now suited on the balcony overlooking the exhibition. I must say that I like the new location. Not only it is closer to the action, but allows you to oversee who is hanging out over the exhibitors.

There’s been a number of interesting sessions, but it’s little things here and there that I learn that provide some real value.

Here’s a few examples

Tomorrow at 8:45 AM GMT time (which is 3:45 AM on my internal EST time clock) I will be doing the updated version of my Memory presentation – “The Answer to Free Memory, Swap, Oracle and everything”. I should perhaps rename it to “Memory Tales from the Middle of the Night” for next year…

Hello Birmingham!

It’s past Sunday midnight and I’m stuck in my room in the last couple hours finishing my slides for my masterclass tomorrow. Turns out that I’m presenting the very first session of the conference at 9am. I wish there is a keynote instead so that I could grab one more hour of sleep (it’s going to be deep into the night back home in Canada). Strange that the keynote was moved to Wednesday — I hope UKOUG has really good reason for that!

My two hours masterclass will start at the same time as Tom Kyte’s a-la keynote session — what a competition. On the other hand, there is no other sessions in server technology so I expect that folks without interest of database development will automatically end up in my session. I’m in Hall 5 – quite large room. Is it the second biggest room after the Hall 1?

I will need to work hard to keep the audience… maybe I shouldn’t plan for any breaks to make sure I don’t let folks slip out to the next sessions like James Morles’ Sane SAN 2010 or Jeremy Schneider’s Large Scale ASM.

My masterclass is based on the slides that I presented at the Oracle OpenWorld few months ago which, in turn is reworked session on Oracle Clusterware internals that I’ve done number of times as long session with demos. I thought updating this material to 11gR2 would be easy… Boy was I wrong!
Read the rest of this entry . . .