Ladies and gentlemen, boys and girls, cats, dogs, goats, cows, furry objects, Kevin Clossen, and whoever else may have accidentally stumbled here: the great blogosphere may have appeared to gradually slow. But fear no more, the tides are changing! You may now stop pinching yourself and trying to find your doctor’s phone number because this [...]
Log Buffer #55: a Carnival of the Vanities for DBAs
July 27th, 2007 § 11 Responses
10g Subquery Unnesting Anomalies
July 18th, 2007 § Leave a Comment
I’ve been spending quite a bit of time over the past week studying subquery optimization. It started with an anomaly I noticed at a client site and led me through a refresher on Jonathan Lewis’ chapter on transformations and through a lot of time reading trace files. I’ll probably write a few posts about subqueries… [...]
NFS and Stats Collection in Oracle 11g
July 12th, 2007 § 1 Response
A few more 11g new features – that you might not have heard about yet – which stand out in my opinion! Direct NFS First, Kevin just posted whitepaper/press release links and made some comments about Direct NFS. Oracle 10g introduced ASM – streamlining hardware access by effectively allowing the database engine to bypass all [...]
Compression in 11g: Time To Pay Attention
July 11th, 2007 § 2 Responses
Well 11g is officially “launched”. I think that just means you can download the white papers from OTN now. Seems that the actual software itself still isn’t available although there was talk that it would be released by August or something – on Linux at least. I’m not exactly holding my breath although I do [...]