"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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
