Archive for

Log Buffer #55: a Carnival of the Vanities for DBAs

Posted by Jeremy ⋅ July 27, 2007 ⋅ 11 Comments

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 … Continue reading →

10g Subquery Unnesting Anomalies

Posted by Jeremy ⋅ July 18, 2007

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… … Continue reading →

NFS and Stats Collection in Oracle 11g

Posted by Jeremy ⋅ July 12, 2007 ⋅ 1 Comment

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 … Continue reading →

Compression in 11g: Time To Pay Attention

Posted by Jeremy ⋅ July 11, 2007 ⋅ 2 Comments

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 … Continue reading →