Richard's Musings

Just a short note to say I’ll be attending and presenting at next weeks Collaborate 2010 Conference in (hopefully) sunny Las Vegas. I’ll be presenting my latest version of Oracle Indexing Tips, Tricks and Traps which was a big hit when I presented it recently at the Hotsos Symposium.  Details are: Session ID: 302 Date: [...]

Thought it was time to update my blogroll with a couple of new additions. Both Charles Hooper and Randolf Geist have provided excellent advice and information on the OTN forums for quite some time and both have excellent blogs that are well worth checking out. They’re also both co-authors in a new Oracle book I’m keen to get [...]

There’s plenty more I could talk about regarding the CBO CPU costing model and system statistics but I’ll make this my final little comment on this subject for now.   As previously discussed, the CPU costing model basically takes the time it takes to perform the all necessary I/O related activities and all the time it takes to [...]

Wow, yet another year almost behind us and what looks like being yet another busy year ahead. Can you believe that The Noughties are nearly all gone, I remember being all excited at the dawn of The Eighties !! I must say I’m really looking forward to finally saying “Twenty Ten” rather than the more long-winded “Two [...]

Well, so much for my plans to not travel as much next year … Found out earlier in the week I’ve now been selected to present at next year’s Collaborate 10 event in Las Vegas. I’ll be presenting a new version of my Indexing Tricks and Traps presentation on Monday, 19 April from 10:45am to 11:45am [...]

I’ve attended and presented at numerous Oracle conferences and events over the years but one conference I’ve never had the opportunity to attend is the Hotsos Symposium, held each year in Dallas, Texas, USA. It’s one of the premier Oracle events, especially for those of us DBAs with a special interest in performance tuning and management and [...]