Archive for

Two days until Asia! Trip Update.

Posted by Jeremy ⋅ September 27, 2007

Two days until I leave for Asia. (You have no idea how busy I’ve been for the past month!) If anyone’s curious about trip details I’ve posted about it over on the non-technical side of my blog.

Cache Buffers Chains and Latch Spelunking

Posted by Jeremy ⋅ September 13, 2007 ⋅ 4 Comments

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

GC Buffer Busy Waits in RAC: Finding Hot Blocks

Posted by Jeremy ⋅ September 12, 2007 ⋅ 28 Comments

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

Posted by Jeremy ⋅ September 2, 2007

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 →