Ardent Performance Computing
Jeremy
GC Buffer Busy Waits in RAC: Finding Hot Blocks
Well I don’t have a lot of time to write anything up… sheesh – it’s like 10pm and I’m still messing with this. I should be in bed. But before I quit for the night I thought I’d just do a quick post with some queries that might be useful for anyone working on a … Continue reading
Formula for db_file_multiblock_read_count
Just sent this to someone in an email and it seems like something that could be useful for everyone. They were asking how to determine the best setting for db_file_multiblock_read_count. First off, you probably will need assistance from a system admin or SAN admin if you’re running on a SAN. And contrary to one popular … Continue reading
Notes on 11g New Features, Part 1
I’ve been AWOL from the blogging world for quite awhile. Been busy for the past few weeks; working on another ITC white paper about RAC, assembled and delivered some internal 11g presentations and right now I’m in DC working with a client… all that has added up and kept me from blogging much. I had … Continue reading
Oracle 11g now on OTN for download!
Download Oracle 11g for Linux now! Looks like it just went up on OTN!!!
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
Case Study: Statspack/AWR Latch Waits (Part 2)
What a day! Yesterday I spent about seven hours downtown taking two exams: the RAC beta exam in the morning and the Oracle on Linux beta exam in the afternoon. The Linux exam was pretty easy for me but the RAC one had a lot of questions that made me think… and there wasn’t much … Continue reading
Case Study: Statspack/AWR Latch Waits (Part 1)
I thought it might be interesting to write about a situation I ran into last week and a bit of the methodology I used to tackle it. The whole thing started as a health check for a PeopleSoft database. To give a little background, the whole environment lives on a 32-processor IBM p690 partitioned into … Continue reading
Disclaimer
This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.
contact: schneider @ ardentperf.com
Ardent Performance Computing 
Recent Comments