{"id":1421,"date":"2008-06-23T12:00:00","date_gmt":"2008-06-23T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1421"},"modified":"2008-06-23T12:00:00","modified_gmt":"2008-06-23T12:00:00","slug":"northern-server-technology-day","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2008\/06\/23\/northern-server-technology-day\/","title":{"rendered":"Northern Server Technology Day"},"content":{"rendered":"

Last Thursday’s Northern Server Technology Day organised by the UKOUG<\/a> was one of the more enjoyable events I’ve attended. It helped that there were no hotels, driving or airports involved, just a simple walk to the train station, a 90 minute train journey (free wireless on hand) and a 10 minute walk at the other end. Given such a short trip, I decided to take a lazy approach and didn’t turn up until the start of the second presentation of the day – Pete Finnigan talking about Security Tools. Although I’m already familiar with a lot of the tools from Pete’s website<\/a>, it was a nice summary containing a few funny security stories so it was a good start to the day.<\/p>\n

Next was Piet de Visser sharing some of his extensive experience with 10g Upgrade Nightmares. I’ve often said that this is my favourite type of User Group presentation. I’m not mad keen on the term ‘war stories’ but users telling other users about the problems they’ve faced (along with the answers) is surely what a user group is for. Piet’s two main messages to take away were one that he’s mentioned in his previous presentations and one that was upgrade-specific<\/p>\n

1) The more simple something is, the better.
2) Try to test against a true file copy of your database and o\/s.<\/p>\n

So that was two out of two good presentations.<\/p>\n

After a quick break for lunch, it was time for mine. The less said about it the better, from a personal point of view. It wasn’t that it was terrible (I don’t think) and several people were very complimentary about it afterwards, but in an attempt to be informal, I tried to avoid it being too ‘scripted’. The fact is that I do have a couple of pages of notes for the presentation, so it wasn’t laziness, but chose to ignore them and take a dive around the OEM Performance Pages. It didn’t really work, most obviously because I spent the rest of the day remembering things that I would have liked to show people and didn’t. So if you didn’t know what to expect, it might have come across reasonably, but I know what it should have been like and it was nowhere near. I’m still convinced it’s a worthwhile presentation, though, and one I’ll revisit. Some of the things I forgot?<\/p>\n

– The Trace this session button.
– Any mention of ADDM.
– Event Histograms (although that I don’t find that particular screen as useful in 10g, where it only shows the range of values since instance startup.<\/p>\n

(Actually, this could go on for a while, so I’ll skip to the two most important …)<\/p>\n

– The acknowledgements slide, thanking some of the guys at Oracle for their help with questions.
– Any mention of Kyle Hailey’s<\/a> Simulated ASH<\/a> or ASH Masters<\/a>.<\/p>\n

Fortunately, I was able to point a few interested parties to the links immediately after the presentation so hopefully ASH Masters will have a few more visitors this week.<\/p>\n

It helped me get over my disappointment that Jonathan Lewis’<\/a> Trouble-shooting presentation was next. I thought it was one of the best 45 minute presentations I’ve seen him deliver because it dealt with an overall approach to performance analysis that utilised the various tools available and showed how they related to each other. Two of the most important sections of the presentation were near the start.<\/p>\n

First, he broke down the Service and Wait components of R= S + W into time spent competing for resources and time spent using resources. For example, from an I\/O wait perspective, some wait time is inevitable whenever you use resources (disk access time, or even cache access time) whereas some wait time could be down to queuing, unable to perform the required work. There was a bit more to it than that, but hopefully you get the general idea.<\/p>\n

He also described the available statistics from the V$ views (or rather their low-level sources) as being in four dimensions.<\/p>\n

Session (or Service or Systems, at higher levels)
SQL Statement
Statistic Type (e.g. Segment Statistics, Latch Statistics and so on)<\/p>\n

By adding the fourth dimension of time, we build up a cube of data and how we analyse that cube depends on the nature of the problem we’re trying to solve.<\/p>\n

It was a terrific presentation in my view because it often isn’t the technical details that people don’t understand when tuning performance problems, but the overall approach which will suit different types of problem. It’s one of the reasons why I wanted to do an introductory presentation on this very subject at UKOUG this year. Now I just need to find a way of saying the same things without saying the same things 😉<\/p>\n

At the end Peter Robson, one of the directors of the UKOUG, asked Jonathan a question about complexity and Oracle’s RDBMS but I don’t think I understood the question fully and I’m not sure Jonathan understood it either or answered it correctly, so I’m trying to encourage Peter to write another guest blog entry. Fingers crossed.<\/p>\n

Afterwards I had a few beers with several of the speakers, Lisa Dobson who had helped organise the day with the usual UKOUG support and a few old friends. (Which isn’t to say that the first two groups aren’t sub-sets of the third 😉) Apologies to Peter Lewis of the BGS for managing to spill my pint over him and his bag! I’m sure whoever was sitting near him on his train home was grateful 😉<\/p>\n

So it was an enjoyable and interesting day out of the office and I’m glad I eventually accepted Lisa’s invitation. Thanks to everyone at the UKOUG who made it a successful day. I have to close on a negative note though (what a surprise) and the latest of a series of reminders to myself.<\/p>\n

I must not talk to my mates during presentations
I must not talk to my mates during presentations
I must not …..<\/p>\n","protected":false},"excerpt":{"rendered":"

Last Thursday’s Northern Server Technology Day organised by the UKOUG was one of the more enjoyable events I’ve attended. It helped that there were no hotels, driving or airports involved, just a simple walk to the train station, a 90 minute train journey (free wireless on hand) and a 10 minute walk at the other… Continue reading Northern Server Technology Day<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1421","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1406,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/27\/upcoming-events\/","url_meta":{"origin":1421,"position":0},"title":"Upcoming Events","date":"April 27, 2008","format":false,"excerpt":"I'll be presenting at a few events in the next couple of months.30th April - OUG Scotland DBA SIG Meeting.This one is the easiest for me to travel to, being just on the out-skirts of Edinburgh, and is always a well-organised event with a decent agenda, thanks to the local\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":902,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/18\/hotsos-symposium-2006\/","url_meta":{"origin":1421,"position":1},"title":"Hotsos Symposium 2006","date":"November 18, 2005","format":false,"excerpt":"My goodness, nearly a week without a blog posting and my review of Jonathan's book still hasn't appeared. It's been a crazy week at work and what little spare time I've had has been spent on getting my server installed. It looks like I won't be able to get wireless\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1466,"url":"http:\/\/orcldoug.com\/blog\/2009\/01\/27\/adding-a-new-oracle-host-to-audit-vault\/","url_meta":{"origin":1421,"position":2},"title":"Adding a new Oracle host to Audit Vault","date":"January 27, 2009","format":false,"excerpt":"This one's been outstanding for a while. After my presentation on Audit Vault at UKOUG, the AV Product Manager Tammy Bednar sent me a couple of corrections to the configuration section. Rather than just amend the slides, I was keen to wait until I had another chance to configure a\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1339,"url":"http:\/\/orcldoug.com\/blog\/2007\/11\/06\/the-reality-gap-3-a-single-instance-per-server\/","url_meta":{"origin":1421,"position":3},"title":"The Reality Gap (3) – A Single Instance per Server","date":"November 6, 2007","format":false,"excerpt":"There will probably be about four or five of these posts in total. This is one I didn't mention in the original presentation because I didn't feel I could do it justice and because there was someone I wanted to have the right to reply. Step forward Tom Kyte.By coincidence,\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":840,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/08\/how-many-slaves\/","url_meta":{"origin":1421,"position":4},"title":"How Many Slaves?","date":"March 8, 2006","format":false,"excerpt":"Parallel Execution and the Magic of 2That's my second presentation, at 2:15 today. I've thought long and hard about this one and hope I've made the right decision. I was concerned about how to encapsulate a 50+ page paper into a one hour slot. I hate presentations which are full\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":898,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/28\/orion-numbers-and-other-bits-and-pieces\/","url_meta":{"origin":1421,"position":5},"title":"Orion Numbers and other bits and pieces","date":"November 28, 2005","format":false,"excerpt":"Prompted by Jeff Moss' blog, I've been trying out Orion on a couple of servers. I've blogged about it over on the ISP4400 blog. (Actually, I've only just realised that hosting the blog html myself probably means I can't use permalinks to individual blog entries. Hopefully the ISP4400 blog has\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1421"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1421\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1421"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}