Well it’s been awhile since I’ve written anything for the blog – during the past four months I went on a trip to Asia, celebrated Thanksgiving and Christmas with both my family and my girlfriend’s family and then in January I got engaged! I’ve also been working on some continuing educational goals – so needless [...]
Oracle I/O and Operating System Caching
January 31st, 2008 § 7 Responses
Cache Buffers Chains and Latch Spelunking
September 13th, 2007 § 4 Responses
Last night I posted a case study where I used the AWR (a blessed new feature) to investigate “gc buffer busy” wait events in a RAC environment. I concluded the write-up by theorizing that the single freelist was pointing all nodes of the cluster to the same small group of blocks for inserts and thereby [...]
GC Buffer Busy Waits in RAC: Finding Hot Blocks
September 12th, 2007 § 28 Responses
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 [...]
Formula for db_file_multiblock_read_count
September 2nd, 2007 Comments Off
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 [...]
Notes on 11g New Features, Part 1
August 24th, 2007 § 1 Response
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 [...]
Oracle 11g now on OTN for download!
August 9th, 2007 § 3 Responses
Download Oracle 11g for Linux now! Looks like it just went up on OTN!!!
Log Buffer #55: a Carnival of the Vanities for DBAs
July 27th, 2007 § 11 Responses
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 [...]