{"id":1378,"date":"2008-01-20T12:00:00","date_gmt":"2008-01-20T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1378"},"modified":"2008-01-20T12:00:00","modified_gmt":"2008-01-20T12:00:00","slug":"advert-oracle-10g-performance-analysis","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2008\/01\/20\/advert-oracle-10g-performance-analysis\/","title":{"rendered":"Advert – Oracle 10g Performance Analysis"},"content":{"rendered":"

As promised earlier, here’s a blog post about some of the thinking behind the course I’ll be teaching in Prague<\/a> on 14th\/15th April (assuming enough people are interested in attending).<\/p>\n

Why I decided to do it<\/b>
Several factors appealed to me when Oracle first asked whether I’d be interested :-<\/p>\n

1) It’s about two and a half years since the last full course I taught and I miss it sometimes, so I’d been thinking of returning to teaching anyway. I taught an average of 10 full weeks per year between about 2001 and 2005 and it’s a completely different challenge from the usual technical work.<\/p>\n

2) I can choose my own subject and write my own material. Working with Learning Tree, the support available from the rest of the business (e.g. Product Development and Marketing) was very useful but could be quite restrictive because they weren’t interested in developing courses that might not have a mass audience. I’m glad I was involved in course development while I was there, though, because it’ll come in useful now. Working with Oracle UK (a long time ago) was worse because I had no involvement in course development whatsoever. <\/p>\n

3) The technical challenges that day-to-day work at customer sites throw up can be interesting, but business pressures sometimes mean that there isn’t time to delve into them deeply enough for my own enjoyment. Anyone who has written or taught courses will tell you that it always adds to your own knowledge because you have to make sure that all the questions have been addressed. To teach a subject, you need to know it really<\/i> well.<\/p>\n

Why I chose this subject<\/b>
So, when I realised I could choose, I had a feeling I might end up picking something performance-related, not least because it’s what I’m really interested in. The other possible direction was professional DBA work (i.e. How the best DBAs handle the job at big sites) but it just felt too amorphous and (not necessarily my choice) the course is part of the ‘Masterclass’ series so I feel the technical content needs to be high. At the same time, I wanted the course to be both bang up to date (so even experienced attendees might learn something new) and timeless (because fundamentals always count and I think I have useful experience). So, 10g Performance Analysis it is and, by 10g, what I really mean is ASH\/AWR\/ADDM\/SQL Profiles and the other nifty tools that are available these days. Yes, only to those who are licensed to use them, but I think a DBA should understand even those tools they might not be using at the moment. Fortunately, I’ve been able to use them extensively at my current site.<\/p>\n

What to expect<\/b>
The course outline<\/a> is fairly detailed and useful as a personal planning aid and sales tool. (Hint: don’t even begin to write something as complex as a course without having a pretty detailed outline at the start. That’s something I learnt from the Learning Tree Product Development people.) but it might be useful for me to highlight specific areas. Here are my three top objectives, in addition<\/i> to the basic course content.<\/p>\n

    \n
  1. To put the 10g ‘Automatic’ features in context with the short but meandering history of Oracle performance analysis. The overall approach needn’t be dictated by the tools and, even with the best tools, if you don’t take the right approach you’ll never get anywhere (or, worse, you’ll get to the wrong place … fast!).<\/li>\n
  2. To include as many examples as possible – some from my day-to-day work and some constructed artificially, because I think both have their place. Coincidentally, a conversation about Swingbench<\/a> cropped up on the Oak Table mailing list just as I was mulling over the examples and it inspired me to take another look. I’d tried messing about with Swingbench in the past but never had enough time to dedicate to it. I might blog about it soon; we’ll see.<\/li>\n
  3. A late addition – I’ve been very impressed by some of the 11g features in this area and I see no reason not to include them. I know it says 10g in the title, but there will be tons of 10g content so I think it can only add to the course. Think of it as a 10g-and-above course 😉<\/li>\n<\/ol>\n

    Why two days?<\/b>
    I spent some time thinking about whether this should be a single or two day course. I hate artificial padding as much as the next techie but, having taught a few courses, I also understand the importance of time to be able to explain things properly, including how these features can actually be used<\/i> rather than just regurgitating the manuals. I also think it’s important for attendees to have the opportunity to discuss the issues, rather than just absorb swathes of detail.<\/p>\n

    I also remembered that a very basic introductory presentation at work on this subject ran to a full three hours, with no significant examples. I want to be able to include some detailed examples and case studies because I feel they’ve been a very notable exception from every performance tuning course I’ve been involved within the past. Without them, it’s just a run through of features and wouldn’t deserve the Master Class title. I’m pretty certain that I’ll have more than enough material to fill two days.<\/p>\n

    There’s a lot of work to get through, but I’m looking forward to it immensely. I’ll be blogging a lot less over the next three months but, rest assured, I expect a few related technical posts to show up here eventually.

    Register here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    As promised earlier, here’s a blog post about some of the thinking behind the course I’ll be teaching in Prague on 14th\/15th April (assuming enough people are interested in attending). Why I decided to do itSeveral factors appealed to me when Oracle first asked whether I’d be interested :- 1) It’s about two and a… Continue reading Advert – Oracle 10g Performance Analysis<\/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-1378","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1552,"url":"http:\/\/orcldoug.com\/blog\/2010\/12\/13\/bratislava\/","url_meta":{"origin":1378,"position":0},"title":"Bratislava","date":"December 13, 2010","format":false,"excerpt":"Oh, actually, there was one more non-technical post I'd forgotten. With such a rush between the course I taught in Bratislava, a quick trip to London for work (and some hairy performance problems) and UKOUG, I never got round to mentioning how the course trip went. First of all, I\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/bratislava1.jpg","width":350,"height":200},"classes":[]},{"id":894,"url":"http:\/\/orcldoug.com\/blog\/2005\/12\/13\/in-praise-of-good-trainers\/","url_meta":{"origin":1378,"position":1},"title":"In Praise of Good Trainers","date":"December 13, 2005","format":false,"excerpt":"I've been thinking about training versus DBA work recently since it's been a while since I did any training work. I noticed an entry on Chris Foot's blog that mentions training which got me thinking even more.There was a time in the late 90s when recruitment agencies would look at\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1384,"url":"http:\/\/orcldoug.com\/blog\/2008\/02\/24\/book-reviews-again\/","url_meta":{"origin":1378,"position":2},"title":"Book Reviews Again","date":"February 24, 2008","format":false,"excerpt":"Remember I said that I'd requested a copy of the Oracle Press ASM book for review? Well I don't know what I was thinking, because the \"Oracle Database 11g DBA Handbook\" turned up instead the other week. I distinctly recall the ASM book being one of the ones I was\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1263,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/01\/oracle-and-community-involvement\/","url_meta":{"origin":1378,"position":3},"title":"Oracle and Community Involvement","date":"May 1, 2007","format":false,"excerpt":"Dammit, I'm going to have to start writing about Oracle again! Even worse, it's not technical but (cough) opinion and analysis \ud83d\ude41I saw Justin Kestelyn's blog last week and my immediate reaction was slightly sympathetic, but I decided to sit back for a few days and watch the fun develop,\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":927,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/22\/competely-ot-zx-spectrum-games\/","url_meta":{"origin":1378,"position":4},"title":"Competely OT – ZX Spectrum Games","date":"October 22, 2005","format":false,"excerpt":"When you're teaching, a personal introduction is almost mandatory to help people get to know you, establish a little credibility and just get everyone talking to each other. Whenever I did mine, I'd explain what I'd done with Oracle, teaching and IT in general, talk about a couple of personal\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1464,"url":"http:\/\/orcldoug.com\/blog\/2008\/12\/18\/performance-on-my-mind\/","url_meta":{"origin":1378,"position":5},"title":"Performance on my mind …","date":"December 18, 2008","format":false,"excerpt":"I've been a bit busy recently because I've had a rolling 4 week cold (like lots of people in the office - obviously several colds in quick succession), a couple of presentations at UKOUG (where I'm sure the additional beer didn't help recovery) and then I was in Vienna on\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1378","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=1378"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1378\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1378"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}