Success is about Imagination

Ignite Your Passion

kyle Hailey

Jan 29, 20102 min read

Oracle Redo Log Waits

In an ongoing effort to document the main Oracle wait events, here is my current effort at documenting Oracle’s redo log related wait...

kyle Hailey

Jan 12, 20109 min read

Oracle Wait: Buffer Busy Wait

Article originally on (with better formating) http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait...

kyle Hailey

Sep 3, 20091 min read

Latch: Cache Buffers Chains

Check out Tanel’s analysis and scripts for cache buffer chains latch contention analysis. Solid stuff: http://blog.tanelpoder.com/2009/08...

kyle Hailey

May 15, 20091 min read

"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 Hailey

May 8, 20091 min read

SQL*Net break/reset to client

Another problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...

kyle Hailey

Apr 30, 20092 min read

Lock Waits: Finding the blocking SQL on Oracle

One 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...