Re: Single record insert intermittently slow

From: Dennis Williams <>
Date: Thu, 27 Oct 2011 12:16:15 -0500
Message-ID: <>

After reading your followup reply, I wonder if the following is happening:
  1. A number of inserts are performed. Recall that they aren't immediately written to disk, but held in memory. So response is very fast.
  2. A threshold is reached. Oracle is forced to flush the buffers - write the blocks to disk. You experience this as a delay.


Received on Thu Oct 27 2011 - 12:16:15 CDT

Original text of this message