Archive

Archive for December, 2007

Where is Storage QoS?

December 21st, 2007 Alex Gorbachev No comments

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…)

Categories: Alex @ Pythian Tags:

SELECT * FROM V$UKOUG WHERE YEAR=2007 AND POST=”FINAL” ORDER BY DAY DESC;

December 18th, 2007 Alex Gorbachev No comments

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…)

Categories: Alex @ Pythian Tags:

“Virtual UKOUG Event”

December 11th, 2007 Alex Gorbachev No comments

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.

Categories: Alex @ Pythian Tags:

SELECT * FROM V$UKOUG WHERE DAY BETWEEN ‘04-DEC-07′ and TO_DATE(’05-DEC-07′)+0.5;

December 5th, 2007 Alex Gorbachev No comments

Yesterday morning, I let myself to sleep longer — I had to be rested before my presentation as the previous evening went quite late. I also had to review my slides and, finally, complete them with couple finishing touches. That means I couldn’t make couple morning sessions. I decided to go to a presentation about Enterprise Manager. Not that I was aiming to learn something new about the product but I was interested to compare my experience with others and the sessions served the purpose quite well.

My own presentation went probably well as far as I could judge following up with people later in the day. The session was in Hall 5, which is a relatively large room — it fits 300+ people. However, the problem in the room was that the light on the speaker (me) was very bright and the light on the audience was dimmed so I couldn’t really see the faces! That meant I couldn’t see the nods, whether the audience is following me as well as their reaction so I couldn’t be sure that my jokes worked (I think I heard few snickers) and this made me even more worrying. According to the information from a reliable source, I looked more worried than usual. I’m afraid this time I couldn’t hide it well enough - I’m always tense at my presentation.

Just before my session I bumped into Jonathan Lewis during lunch time and he asked me if it’s true that I fell asleep in the middle of his session. To give you some background, (more…)

Categories: Alex @ Pythian Tags:

ORADEBUG TRACE UKOUG_EVENING STATE DUMP, DAY 1

December 3rd, 2007 Alex Gorbachev No comments

ORA-600 [42].

Well, this was a nice Oracle Bloggers Meetup this year. It was less crowded compare to last year which is a bit surprising if you think about it — there are more and more Oracle bloggers around. On the other hand, it let me focus more talking to participants of Oracle blogosphere and other social networking Oracle related crowd and I met quite a few new faces.

Bloggers Meetup at UKOUG 07

On the other hand, I liked more last year’s blogging gathering when there were 3 events clashing together with larger crowd. I also think that few key personalities were missing this year but that’s life.
(more…)

Categories: Alex @ Pythian Tags:

SELECT * FROM V$UKOUG WHERE DAY BETWEEN ‘03-DEC-07′ and ‘04-DEC-07′;

December 3rd, 2007 Alex Gorbachev No comments

As you probably guessed I didn’t have a chance for a nap yesterday as I mentioned. All the usual suspects gathered in the Jury’s Inn pub sipping beer. Some of us went for dinner in the Indian restaurant after which I ended up in All Bar One and then later in Tap and Spile with more traditional old style atmosphere and nice selection of ales on tap. Even though they had Guinness, I decided to enjoy London Pride premium ale — very smooth with interesting combination of flavors. Indeed, “the sensation of angels dancing on the tongue” as described by Stephen Cox, a famous beer writer. But that was yesterday so moving on…

Unjustifiably early start today at 6:30 (your fault Christo). After registration, we tried to find some breakfast across the bridge from the rear entrance to the ICC but no luck. I always wanted to have a breakfast on the boat that is parked on the canal below the bridge and this morning we decided to wait until 9AM when it supposed to be open for breakfast according to the ad on it. No luck - it was still closed and looked dead at 9:05 and 15 minutes later I saw the boat leaving.

We had interesting speaker gifts — motion powered torch and radio:
(more…)

Categories: Alex @ Pythian Tags:

Getting Ready for UKOUG 07 in Birmingham

December 2nd, 2007 Alex Gorbachev No comments

Christo Kutrovsky and me arrived in Birmingham today - just 6+ hours direct flight from Ottawa to London and two and a half hours on the bus - not too bad compare to 30+ hours travel from Melbourne to Ottawa earlier this week. It’s cloudy with sporadic rain drops but warm. We couldn’t checking at 11 AM and leaving our luggage behind, went for a short walk and some lunch.

I was very surprised to find German-style Kristkindlmarkt in Birmingham - Christmas Market:

Birmingham Kristkindlmarkt 1 Birmingham Kristkindlmarkt 2

Birmingham is very nice. Christo loves its European neatness and style — he enjoys “walking” cities. After lunch (it was OK) we checked in Copthorne Hotel and I asked for a room with internet — not every room has it, apparently. The internet cost is just £9.95 for the duration of the whole stay. It ACTUALLY says £20 for 24 hours DURING online registration but the hotel staff assured me it’s a mistake. I hope they know it better on reception.
(more…)

Categories: Alex @ Pythian Tags: