Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: When to use _disable_logging on Oracle 10g Release 2
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-lReceived on Tue Oct 11 2005 - 13:24:14 CDT