Re: Single record insert intermittently slow
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: Sidney Chen <huanshengchen@xxxxxxxxx>
- Date: Thu, 27 Oct 2011 12:16:15 -0500
Rich,
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.
Dennis
--
//www.freelists.org/webpage/oracle-l
Other related posts:
