Today is Hotsos Symposium 2008 Training Day — one full day with Tom Kyte. I haven’t registered for it so I took the chance to sleep until 10 this morning which was excellent idea considering that last night we were quite late going to bed thanks in parts to the joined demo that James Morle and Mike Erwin organized at the last presentation yesterday. I was in the James’ session and he was demonstrating how to hide latency problem with batching. I suspect that Mike, in the next hall, was showing the impact of MTU settings on cluster interconnect. The end result is that beer bottles travelled between the presentation halls and James ended up with about 3 packs of Guinness and Shiner Bock. That what kept us up longer last night.

James’ presentation itself was excellent — he explained that all performance problems can be caused by either skew or latency. You can’t normally fix skew issue so you just need to be aware and account for it. Latency can sometimes be shortened but usually insignificantly or it’s impractical (i. e. very expensive). It’s also very important to distinguish bandwidth and latency. I like his idea that the efficient way to solve latency is hiding it and there are generally two ways to do that — batching and threading. Improving bandwidth often doesn’t cause any performance improvement without taking latency into account. Very insightful talk. Thanks James.
(more…)

The symposia is still ongoing and my head is slowly filling up — relieved from my presentation, finally, I’m able to focus on others’ sessions.

Yesterday, Tanel Poder presented his new tool Sesspack and his integration with Excel. 3 years ago, I created a similar tool and collected session waits and statistics transformed into differences per the interval and organized in the star schema to simplify the analysis. I tried to write a front-end in PHP — it was taking ages and I didn’t have time. Then I tried APEX (HTMLDB 1.6 back then) and it wasn’t flexible enough. I ended up querying the data directly and copy & paste to Excel where I could use pivot charting. What a great feature of Excel — it let me organize the data easily and visualize the problems to management, system and storage administrator and other DBA’s. I moved on and didn’t have time to continue this project, clean it up and put into public domain. I’ve still had it in my mind but there is no need now since Tanel already did far better job. He put the first version of the Sesspack on his web-site about half a year ago. What excited me more this time was the integration with Excel that he did — what a powerful but simple tool in the hands of a smart DBA. I’m looking forward to use it when it becomes available on his web-site.
Update: Tanel put the material on his web-site here.
(more…)

I didn’t mention the most exciting news of the yesterday (well, for me at least) — I’m a member of the Oak Table Network now! I’m so delighted and proud to be the part of that group and also very grateful for the invitation to join those bright people.
.

It’s actually old news now (thanks Doug and Marco) but I thought that I should proudly state it here. On the other hand, “someone” mentioned that “They’ll let *anyone* in these days!”. OK eh… where is the application form?

First of all “the before” time is over — I’m done with my presentation. It’s been the first slot of the day — 8:30 and Cary Milsap was presenting in another hall so what chances do I have to get people in? It turned out that some people actually did show up and quite a few considering the circumstances.

I have mixed feeling on the results. The presentation started very well and I managed to wake people up at the very beginning — thanks to the “equipment” I had at hands (thanks Marco and Riyaj!). You can spot one of them on the photo (thanks for the photo Marco):

(more…)

Last year’s Hotsos Symposium was the first for me. These were exciting few days and I fully enjoyed the conference. I’m very pleased that this year I’m going to Dallas again but this time in the new role — I’m doing a presentation there.

I don’t need to tell you what Hotsos Symposium is about — if you are on this blog, you should know it already. 3 days of high quality presentations and endless networking opportunities where you can share your ideas or concerns and get your questions answered.

My presentation is the first one on Tuesday — 8:30! It’s my first time presenting at Hotsos and I feel somewhat more tense than usual (as if I take it easy every time). I’m not the only new presenter at Hotsos and I know that Robyn Sands is doing her first Hotsos presentation as well (come on Robyn, when can I put that link on your name? ;). Anyway, I guess my sessions would not be attended by a huge crowd — it’s early and Cary Milsap is speaking in the next hall so people must be really interested in my topic to come to mine.

The topic of my presentation is Workload Management in Oracle RAC. I’m quite happy with the end result but I might have a little bit too much material to cover in 1 hour. I expect to spend most of the time in the “demo mode” on my 10g and 11g RAC clusters running on virtual machines on my MacBook. Depending on how it goes, some demos could span a bit longer than I plan depending on position of the moon and stars on Tuesday. I have a contingency plan as I really have to get to the last demo — it’s the coolest part of the session, I think.

I’m still rehearsing the demo and polishing the white paper. Excluding demo placeholders and navigational slides, I have just a little over 20 slides so not much efforts there. Most of the stuff I demonstrate “live” but a lot of details are in the white paper + demo examples provided to follow.

In addition, to the presentation, I will take part in the “Hotsos Campground” sessions on Monday and Tuesday evenings. There will be four of them and each is focused on a particular topic. I’m going to participate in the Hotsos RAC Campground. No surprise. Eh?

My plane leaves at 9:30 tomorrow. I hope there won’t be much snow and I leave on time — today is the first day of the spring on the calendar but I still did my 2 hours shoveling exercise. I think I’m getting better on it and it takes me half of the time I used to spend 3 months ago. Interesting, how much more can I improve?

Anyway, I hope I won’t need to do it again this year. Olga and Alex Jr. are joining me in Dallas after Hotsos and we are going to spend almost 10 days traveling around and, hopefully, enjoying some bits of sun. Bye, bye snow!

The time is flying here and two days of RMOUG Training Days 2008 have gone. In a nutshell, what a great conference! Well done RMOUG and special thanks to Peggy King!

It was very nice to see a bunch of old friend and meet new ones in person including Jeremiah Wilton and Tim Gorman.

I liked the lunch organization — everyone was seated and nice food served — way better than standing buffet. The area with the tables was also used for the breakfast and this is where the keynote was done — excellent idea to combine those together:

(more…)

It’s been a while singe I blogged last time. Not that I’m feeling guilty — it’s coming whenever I have the mood and time left — but I kind of missed it. I have enough to share for few blogs a day and let’s hope I make it more often. But I digress.

I’m in Denver now and it’s RMOUG Training Days time! The University Sessions were running yesterday and the conference itself starts today. I have heard a lot of good things about RMOUG and the conference is considered as one of the best Oracle events in North America. I will be able to confirm it during the next two days but I have no doubt that it’s true.
(more…)

In the era of consolidation, storage has not been left out. Different systems are made to share the same storage boxes, fiber-channel switches and networks. Inside a typical storage box, we have front-end and back-end controllers, cache, physical spindles shared amongst different applications, databases, backup destinations, and so on.

The impact of backup on normal database activity . . . batch processing in one database impacting transactional processing — these are two real life examples of the consequences of storage consolidation known to almost every DBA. Of course, it’s easy to suggest separating databases to different physical disks, but what about SAN box controllers and shared cache? And don’t forget about the cost factor and ubiquitous consolidation that forces storage administrators to pack as much data as possible into a single SAN or NAS storage device.

Some of our customers use hosting services — they outsource hardware hosting just like they outsource DBA work to Pythian. In such scenarios, hosting service providers usually have storage hardware shared amongst different customers to provide higher utilization and on-demand storage capacity at a lower cost.

(more…)

Mind you this was actually written more than a week ago but I didn’t have time to review and upload the photos on time so sorry for this delay.

I’m on the plane back to Canada and I’m extremely satisfied with the conference this year. I should say that I found it harder to keep up in the evenings with some slightly non-sober DBA’s around and get up “early” in the mornings to visit several good morning technical sessions. You might blame age but I shouldn’t complain… not yet, at least!

Enough whining… This is my final UKOUG 2007 post as you might have figured already so let’s get to it.

The last day was the shortest but the most difficult. I set my alarm at 8AM and it worked, unfortunately. I got up but couldn’t find my way around bouncing from the walls and bumping into the corners so I had to catch another couple hours of sleep. I could only wake up after 10 and by the time I took a shower, packed my luggage and checked out, it’s almost the middle of Doug Burns’ presentation and I didn’t want to disturb his speech which was very good I heard. Christo’s presentation was over by that time but I saw it already anyway in a full 60 minutes format so I didn’t really need a 45 minutes refresher. In addition, I can always shout in the office if I need an answer to a memory questions.

I waited in the speaker lounge until Doug’s session is over and used this opportunity to chat with few other speakers and later bumped into Lisa Dobson (or did she bump into me?). I had an interesting observation that we both were whispering and my explanation would be that we didn’t want to bother several other speakers who were focused on work, presentations and emails. There is another theory as well but I like this one more. ;-)
(more…)

This message is for our readers mostly located in UK and Europe but keep reading even if you are far away geographically - nothing is impossible in our digital age and you might actually consider traveling there in case of desperate interest. Your feedback would be useful, either way.

What I want to draw your attention to is that Jonathan Lewis has posted a call for attendees for a special event dedicated to virtualization technologies with Oracle. This event is considered by UKOUG and whether it happens or not depends on you.

I had a brief discussion with Jonathan at the UKOUG Conference in Birmingham last week and shared significant interest about virtualization that I can see from our customers as well as a fear cloud around it. From my point of view, an event dedicated to virtualization technologies would be very timely now to satisfy quickly growing interest and provide real world experience in addition to publicly available marketing-like information from different vendors. Knowing high quality of UKOUG events, I’m sure that this would be a great forum to share ideas and learn what others do with virtualization.

Have a quick look here if haven’t done so already especially if you are closer to managerial role or wear architect’s hat rather than DBA’s one. It’s not only about host virtualization but also network, storage and other resources.