Re: Inserting performance issue

Did you trace the process? If not, we could only guess.

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

-- 
Ron Reidy
Oracle DBA