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 23:41:05 GMT
Message-Id: <pan.2006.08.08.23.41.03.991134@gmail.com>

On Tue, 08 Aug 2006 14:56:30 -0700, joel garry wrote:

>
> 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.
>

Good call.

-- 
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 - 18:41:05 CDT