Re: Fast utility to transfer data from one database to another excluding IMP/EXP

HansF wrote:
> On Tue, 08 Aug 2006 20:55:12 +0200, Maxim Demenko wrote:
>
> >
> > Actually, it seems to be a very funny thread now.
> > I didn't know before, that /** append */ (i.e. a simply comment) can so
> > improve performance... But , should be of course tested - and on my
> > linux box - it seems, Oracle scales with the count of tests ;-)
> >
>
> Of course, to do this properly, we should also flush the shared pool.
>
> And put it into a script and rerun it 6 or more times to ensure that the
> results are repeatable.
> (http://www.brainyquote.com/quotes/quotes/b/benjaminfr109067.html)

Therefore, the essence of science is insanity :-)

I think the timing results of your inserts before the truncate should be thrown out due to possible segment extension issues.

jg

--
@home.com is bogus.
http://www.gap-optique.unige.ch/Members/olivier.landry/quotes.txt