Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disable logging in tablespace vs using hidden parameter _disable_logging

Re: Disable logging in tablespace vs using hidden parameter _disable_logging

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Thu, 2 Feb 2006 11:12:04 -0800 (PST)
Message-ID: <20060202191204.34051.qmail@web301.biz.mail.mud.yahoo.com>


Hi,    

  I do not think setting "_disable_logging" to true , will have much affect on the import performance, if imp has been tuned properly.    

  Secondly if you are on 10g , datapump is an alternative.    

  Regards    

  Joseph Amalraj       

Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:   Hi I was asking my self, and I decided to ask people who knows better about it:

Which is the difference if I set all tablespace to nologging vs if I set the hidden parameter to disable logging _disable_logging. To get an import to development environment faster.

I know I can't recover if there is a problem, etc, etc. The question is which is the real difference.

.) Thank you
--

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 02 2006 - 13:12:04 CST

Original text of this message

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