Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance issue while loading large amount of data
EP wrote:
> Hello
>
> I am supposed to load large amount of data from SQL scripts and I have been
> wondering what is the best option:
> -frequent commits and no rollback segments growth
> -one commit and large rollback segments
> What do you suggest ?
>
> Regards
> EP
Depends on the qualify of the data.
What percentage of the rows are rejected do to constraint violations?
Daniel Morgan Received on Sat Jan 11 2003 - 13:19:37 CST