Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.txtReceived on Tue Aug 08 2006 - 16:56:30 CDT