{"id":1553,"date":"2009-12-13T12:00:00","date_gmt":"2009-12-13T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1553"},"modified":"2009-12-13T12:00:00","modified_gmt":"2009-12-13T12:00:00","slug":"my-favourite-oracle-blog","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2009\/12\/13\/my-favourite-oracle-blog\/","title":{"rendered":"My Favourite Oracle Blog"},"content":{"rendered":"

Some features in this post require a Diagnostics Pack license.<\/p>\n

<\/em>I think there a quite a few decent Oracle blogs around. There are links to some of them over there on the right. But by far my favourite this year has been Kerry Osborne’s<\/a>. I think there are a number of reasons.<\/p>\n

1) We have similar interests in Oracle performance in general and the Diagnostics Pack features in particular.<\/p>\n

2) His posts are nearly always technical but not just for the sake of it or to impress. I like to learn new and deep stuff as much as the next guy, but if the number of times I send links to colleagues who are trying to solve a problem is any indication of technical value, then Kerry’s is almost at the top of my list.<\/p>\n

3) I think he writes really well, in a readable, conversational style and always shows examples that are rigorous and reflect most people’s day-to-day IT reality.<\/p>\n

4) He shares useful scripts. I’m going to revisit that point in a future post about some of the tools I find useful.<\/p>\n

I know I’ve mentioned Kerry’s blog before, but no apologies for recommending it again. It’s how I’d like my blog to be, really. Not jealous; just inspired! Oh, and for the avoidance of any doubt, we’re not mates or anything, but I may buy him a couple of beers at Hotsos to thank him for those occasions when his stuff has helped.<\/p>\n

But there is a technical point in here somewhere. I noticed his recent post about tracking Oracle parameter changes in AWR<\/a> and it reinforced nicely a point I make when I’m teaching people about AWR. Never under-estimate how useful it is in DBA trouble-shooting of problems which are entirely unrelated to performance. AWR is often relevant for solving problems where a history<\/em> might be useful. I’ve used the parameter change example in the past myself – who set this parameter, when and why? It won’t answer most of those questions, but once you know the when, it might help answer the other questions too. Another use I’ve found is in looking back at when precisely (well, to the nearest hour) the free space in a tablespace dropped dramatically so that we could try to narrow the reasons why. <\/p>\n

All I would say is that if you have the licenses and something like this crops up, check to see if there’s a DBA_HIST view that might help. (Oh, and if you don’t, just use Statspack instead. Doesn’t have quite as much information, but pretty close. Or just write your own similar utility)<\/p>\n

Kerry also talks about AWR retention and I know a lot of people increase the retention from 7 days to something like 35 days, to cover an entire monthly workload cycle. It depends on your system, of course. However, I am a big fan of long AWR retention periods, much longer than I find people using, because the history of a system is so<\/em> useful when tracking performance changes over time. I’ve lost count of the number of times when I’m looking at gradual performance degredation over time and wished I could have some more AWR data to hand.<\/p>\n

As for sizing, there’s a pretty simple solution – just use the supplied $ORACLE_HOME\/rdbms\/admin\/utlsyxsz.sql script. What I like about it is that it supplies very sensible defaults for your system, based on existing data and gives you pretty detailed information about what is going on inside your SYSAUX tablespace. It’s one of those little, apparently simple things that I find people are still unaware of for some reason.<\/p>\n","protected":false},"excerpt":{"rendered":"

Some features in this post require a Diagnostics Pack license. I think there a quite a few decent Oracle blogs around. There are links to some of them over there on the right. But by far my favourite this year has been Kerry Osborne’s. I think there are a number of reasons. 1) We have… Continue reading My Favourite Oracle Blog<\/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-1553","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1289,"url":"http:\/\/orcldoug.com\/blog\/2007\/07\/04\/awr-licensing\/","url_meta":{"origin":1553,"position":0},"title":"AWR Licensing","date":"July 4, 2007","format":false,"excerpt":"I thought I'd wait for a few days to see how the open letter to Larry Ellison on the subject of AWR licencing panned out.I love AWR, ASH and I even have an increasing, slightly grudging and cynical respect for ADDM. In fact, I'm in the course of putting together\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1515,"url":"http:\/\/orcldoug.com\/blog\/2009\/09\/01\/11-2-release\/","url_meta":{"origin":1553,"position":1},"title":"11.2 Release","date":"September 1, 2009","format":false,"excerpt":"Some features in this post require a Diagnostics Pack license. I noticed my Netvibes home page light up today with the release of 11.2 on OTN (Greg's is just one of a bunch of posts) - official home page here.More important to me was the documentation and there were two\u2026","rel":"","context":"With 27 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1422,"url":"http:\/\/orcldoug.com\/blog\/2008\/07\/05\/server-technology-conundrums\/","url_meta":{"origin":1553,"position":2},"title":"Server Technology Conundrums","date":"July 5, 2008","format":false,"excerpt":"[The following is a guest blog post courtesy of Peter Robson, prompted by this event that we both attended. Peter's a good friend, I love his writing style and he's expressed similar opinions in the past to me, so I asked if he would write them down for a wider\u2026","rel":"","context":"With 25 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1403,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/17\/moving-awr-data\/","url_meta":{"origin":1553,"position":3},"title":"Moving AWR data","date":"April 17, 2008","format":false,"excerpt":"Note - features in this post require the Diagnostics Pack license[I originally had the first section at the end of the blog post, but then realised I might as well get the bad news out of the way to save you wasting your time if you're not interested]A small section\u2026","rel":"","context":"With 4 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":1553,"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":1283,"url":"http:\/\/orcldoug.com\/blog\/2007\/06\/10\/blogs-oracle-com-part-2\/","url_meta":{"origin":1553,"position":5},"title":"blogs.oracle.com … part 2","date":"June 10, 2007","format":false,"excerpt":"OK, I finally have a few technical things worth blogging about, so let me get this non-technical one wrapped up first. Here's part 1.The other part of Kevin's blog that was very relevant to my recent musings was the section titled 'Aristocracy or Meritocracy'. He talks about the close contact\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1553","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=1553"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1553\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1553"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}