Archive for

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

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

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

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

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


This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.

contact: 312-725-9249 or schneider @ ardentperf.com




Enter your email address to receive notifications of new posts by email.

Join 56 other subscribers