09 May 2006
I was recently involved on a problem for a critical production database that had slow response time for inserts. The batch job inserting was running at full tilt, and adding more processes (concurrency) was not helping. Ah, there must be some contention going on. What was interesting was not the particular technical details of increasing insert performance, but rather, differing perspectives on how to figure out the problem, and how to suggest a fix.Â The insert process was inserting data into a long raw column of images. v$session_wait showed many sessions waiting on buffer busy waits.