RE: Re[2]: Datafile Migration Tool

"Imports/exports only use about 1/10 of your available sustained io
generally. Although direct exports are noticably faster and less stress on the database."

And why do we need to read this?

        Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics.

"Locking, rollback generation, constraints, triggers can affect the
performance of the import/export process as well. Also network io if it isn't a local export/import."

Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this

        Use the delete key, again, I don't care what you read and what you don't read. That is your choice, the delete key is your choice.

"Direct path exports do not effect the speed of imports. Unless your using
SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses."

SQLLDR cannot use sxport dump file as a source

        Agreed. Merely stating import speed is not effected by direct exports. Only direct sql loads using sqlldr is it's "import" speed effected". There is a lot of confusion that direct exports effect the speed of the import as well. This is false.

"Conventional exports are cpu bound, where direct path exports are io
bound."

Who told you so?

        A little bird, and Oracle, as well as testing and experimenting.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863  

-----Original Message-----
Sent: Thursday, August 16, 2001 11:52 AM To: Multiple recipients of list ORACLE-L

"Imports/exports only use about 1/10 of your available sustained io
generally. Although direct exports are noticably faster and less stress on the database."

And why do we need to read this?

"Locking, rollback generation, constraints, triggers can affect the
performance of the import/export process as well. Also network io if it isn't a local export/import."

Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this

"Direct path exports do not effect the speed of imports. Unless your using
SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses."

SQLLDR cannot use sxport dump file as a source

"Conventional exports are cpu bound, where direct path exports are io
bound."

Who told you so?

Alex Hillman

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).