kyle HaileyJan 29, 20102 minOracle Redo Log WaitsIn an ongoing effort to document the main Oracle wait events, here is my current effort at documenting Oracle’s redo log related wait...
kyle HaileyJan 12, 20109 minOracle Wait: Buffer Busy WaitArticle originally on (with better formating) http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait...
kyle HaileySep 3, 20091 minLatch: Cache Buffers ChainsCheck out Tanel’s analysis and scripts for cache buffer chains latch contention analysis. Solid stuff: http://blog.tanelpoder.com/2009/08...
kyle HaileyMay 15, 20091 min"kksfbc child completion"I’ve run into the wait “kksfbc child completion” a few times over the past but found very little written about it. I don’t have an...
kyle HaileyMay 8, 20091 minSQL*Net break/reset to clientAnother problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...
kyle HaileyApr 30, 20092 minLock Waits: Finding the blocking SQL on OracleOne of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the...