Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fast utility to transfer data from one database to another excluding IMP/EXP

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

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Tue, 08 Aug 2006 19:16:28 GMT
Message-Id: <pan.2006.08.08.19.16.28.94875@gmail.com>


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)

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.
Received on Tue Aug 08 2006 - 14:16:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US