Re: Single record insert intermittently slow
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 27 Oct 2011 12:16:15 -0500
Message-ID: <CAGRGHjxpj_DsXZv-R1V4mYkWm+sBxQLh=60fDUQmn_rduF+A+w_at_mail.gmail.com>
Rich,
After reading your followup reply, I wonder if the following is happening:
Date: Thu, 27 Oct 2011 12:16:15 -0500
Message-ID: <CAGRGHjxpj_DsXZv-R1V4mYkWm+sBxQLh=60fDUQmn_rduF+A+w_at_mail.gmail.com>
Rich,
After reading your followup reply, I wonder if the following is happening:
- A number of inserts are performed. Recall that they aren't immediately written to disk, but held in memory. So response is very fast.
- A threshold is reached. Oracle is forced to flush the buffers - write the blocks to disk. You experience this as a delay.
Dennis
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 27 2011 - 12:16:15 CDT