RE: Import Question

I don't think Jared meant to just turn off automatic archiving, I think he meant to take the database out of archivelog mode (turning off archiving completely, not just auto-archiving). Seems to me that turning off archiving will save you the extra I/O of reading your online logs and writing to the archives - which could make a significant impact considering you're already performing a heavy I/O operation to begin with, especially if you have your archivelogs on the same disk with other database files (not recommended, I know). Also, it will save you from having to deal with the trouble of filling up your archive log dest, and/or having to constantly delete or back them up.

Regards,
Brandon Allen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Drake Sent: Thursday, August 18, 2005 1:35 PM
To: jkstill_at_gmail.com
Cc: fred_fred_1_at_hotmail.com; oracle-l_at_freelists.org Subject: Re: Import Question

btw - turning off automatic archiving for a database running in archivelog mode (pre-10g) won't really speed things up ;)

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l