Re: Inserting performance issue

If your INSERT process is waiting on checkpoints, or whatever, these will be reflected in V$SESSION_EVENT and V$SESSION_WAIT for that specific session. You'll have to drill down into your bottlenecks to know more.

HTH,
Brian

don wrote:
>
> Hi
>
> I have several batch jobs to insert a lot of data to DB, they run
> hours.
> The rate of insert varies, at begining it is slow, then it speeds up,
> sometimes dramatically, then later it slows down again.
> Is it because DB Writer wait till checkpoint to write, or what is
> exactly explanation?
>
> Thanks,
> Don

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"