Re: When to use _disable_logging on Oracle 10g Release 2
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Tue, 11 Oct 2005 13:58:20 -0400
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@xxxxxxxxx> wrote:
> On 10/11/05, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> 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
- References:
- When to use _disable_logging on Oracle 10g Release 2
- From: Juan Carlos Reyes Pacheco
- Re: When to use _disable_logging on Oracle 10g Release 2
- From: Niall Litchfield
Other related posts:
- » When to use _disable_logging on Oracle 10g Release 2
- » Re: When to use _disable_logging on Oracle 10g Release 2
- » Re: When to use _disable_logging on Oracle 10g Release 2
- » RE: When to use _disable_logging on Oracle 10g Release 2
- When to use _disable_logging on Oracle 10g Release 2
- From: Juan Carlos Reyes Pacheco
- Re: When to use _disable_logging on Oracle 10g Release 2
- From: Niall Litchfield