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: Export speed

Re: Export speed

From: Clay Davidson <clay_at_his.com>
Date: Sun, 3 May 1998 20:39:03 -0400
Message-ID: <354d0dcf.0@news4.his.com>


Are you using the same buffer size. That can make a big difference. Are you estimating statistics on one and not the other. Are the parameters EXACTLY the same?

If they are, then I dont have a clue why one would be faster than another.

ali beidoun wrote in message <354B5B89.19F46EAA_at_donau.de>...
>Hi all,
>
>Does anybody know why an export using the SYSTEM account giving an owner
>is much (about 3 times) faster than the export using the user account?
>The CPU utilization of our system (NT4, Oracle 7.3.4 and without any
>connections to the database except export) was in both cases about the
>same.
>
>Thanks for your replay.
>ali
>
>
>
Received on Sun May 03 1998 - 19:39:03 CDT

Original text of this message

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