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: When to use _disable_logging on Oracle 10g Release 2

Re: When to use _disable_logging on Oracle 10g Release 2

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 11 Oct 2005 13:58:20 -0400
Message-ID: <cd4305c10510111058s2385587fq2654c662f38aeb72@mail.gmail.com>


Thanks Niall, well definetively I don't think to use it anyway, except on that weird pressure on a database :)
On 10/11/05, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> On 10/11/05, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> > Hi,
> > Well after a stress tests, and other test, in the previous days,
> > losing a test database because redo logs corruption.
> >
> > using the parameter _disable_logging on Oracle 10g Release 2 and
> > thanks to several comments in this list I can say.
> >
> > You can get useful improvements using this paramters, but...
>
> <snip>
> > 2)
> > The only reason I found feasible to use it is when you have to import
> > urgently (for example for a presentation) in 0:30 or tomorrow.
> > Otherwise you can end losing your database.
>
>
> nope. you can always end up losing your database with this set, you better
> recognise it. time pressure is irrelevant (well actually improves the
> likelihood of making a simple error and losing the db yourself)
> _disable_logging would be better renamed
> _I_REALLY_REALLY_REALLY_DONT_CARE_ABOUT_THIS_DATA. If you
> set it, that is what you mean.
>
> oh, and importing for a presentation, what a weird pressure on a database.
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com

--
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
Received on Tue Oct 11 2005 - 13:24:14 CDT

Original text of this message

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