Log Buffer #20: a Carnival of the Vanities for DBA’s
Like me, it appears that there are still a few bloggers out there trying to get back to normal after the UKOUG conference, yet there have still been a lot of posts to get through this week.
Mark Rittman in particular has had to do more ‘recovering’ than others, and we’re not just talking about a lack of sleep!
Luckily, his appeal for a ‘Distributed Recovery’ seems to have worked and people have rallied round to help him out.
As a result, Peter Scott has commented on ‘A sense of Community’, a post about how the blogging network, and the Oracle community as a whole, is a very supportive place to be.
In addition to helping out, there is also a great social element to this community. Judging by some of the photos that Doug Burns has linked to I think there are some people who would have preferred it if cameras had been banned from the event!
If anybody missed the UKOUG conference, then Piet de Visser has a great summary post of the event.
Going back to Doug Burns for a moment, on his UKOUG – Day 4 review he also posts about a strange issue with Oracle licensing around AWR in 10.2. This was talked about a lot at the conference and was also picked up by Jonathan Lewis on his AWR Dilemma post.
It seems that if you’re not licensed to run AWR, then you can quite easily disable it by running a simple procedure call. However, you can’t run the package unless you are licensed to run AWR.
It reminds me of the time in my Java Programming 101 class where I created a loop that wouldn’t end…..
Moving away from the UKOUG conference, it looks like Tom Kyte has been doing some interesting travelling (again!). He left the conference early and has been out and about in Rome. He has some great photos, although it sounds like some of his seminar material may have been lost in translation!
A couple of ITToolbox articles have also caught my eye this week.
The first one is a Confession of an IT Hitman on ‘How to Use Oracle (19) – Intro to indexes’. It’s a good article on how SQL performance tuning is not just about creating as many indexes as possible.
The second article is by Chris Eaton of An Expert’s Guide to DB2 Technology on the MERGE statement, something I learned about on a recent Oracle Warehouse Builder project.
Over on the PostgreSQL Planet blog, we have Robert Treat talking about why usability matters. Since reading it, I’ve discovered that I don’t have any problems with the light switches in my house, however the locations of the plug sockets on the walls leaves a lot to be desired!
Speaking of plugs, Eddie Awad has a useful post on using Oracle search plug-ins (See how I did that?!) Eddie shows how you can install search plugins in either IE7 or Firefox 2 and also how to use Oracle custom search engines powered by Google.
For the MySQL users, on Arjen Lentz’s Blog, there is a call for papers for the MySQL Miniconf 2007 in Sydney, Australia.
Mike Kruckenburg also has a couple of posts on his blog about MySQL. The first is how to use MySQL to generate bar graphs, and the second is on his MySQL Cluster set-up.
If security is your area of interest, then make sure you take a look at Pete Finnigan’s website. This week he expresses some concerns in his post on the intended 0-day exploit for Oracle bugs, a story which is also picked up by Chris Eaton.
For a different viewpoint, go back to the PostgreSQL Planet blog. Here, Magnus Hagander has an Interesting analysis of db security.
On a congratulatory note, I see that Lutz Hartmann has been nominated to receive the Oracle Ace award.
In DBAzine, there are two articles that stand out.
Firstly, Craig Mullins claims that DBA’s out-earn other IT staff positions which is always good to hear!
Secondly, Chris Foot continues his System Triage theme with the first part in the series on Access Path Identification. A detailed article and well worth a read.
And finally, I’ll end with links to two posts, both of which stand out for their entertainment value, rather than technical content!
We all know that Mogens Norgaard is not a man to shy away from controversy.
If you’re sitting comfortably then I suggest you read his latest post in which he recounts Kurt Van Meerbeeck’s presentation story of how the CIA stole Oracle from the Russians and why you should beware of Jonathan Lewis!
Once you’ve done that, then click on over to see Steve Karam, the Oracle Alchemist.
This post will provide you with the lyrics you need to give a rousing rendition of a DBA’s take on a classic Don McLean Song.
Let me know how many of you are still singing it on Monday morning!!
Well, that’s it for this weeks edition of Log Buffer!