Re: Logging

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 28 Jun 1999 08:56:38 -0700
Message-ID: <37779B36.1A35D075@us.oracle.com>

Standard disclaimer for those who haven't seen it before. Any of the underscore parameters (they call it underbar here in the US - strange!) are not to be used without Support telling you to blah blah blah ...

Pete

Jeremiah Wilton wrote:

> > Harris wrote:
> >
> > > Is there any way to turn ALL logging off? In the oracle8 documentation,
> > > it says the NOLOGGING option does not affect INSERT...values
> > > statementes, which is all that I am doing! We are trying to get very
> > > quick response times, and hopefully turning off logging may help.
>
> On Thu, 24 Jun 1999, Pete Sharman wrote:
>
> > No, it's impossible to turn ALL logging off. You might get very fast
> > response times, but the database would never be recoverable from even
> > things like power failures if we allowed that.
>
> Well, there is the _DISABLE_LOGGING initialization parameter. I'm not
> sure what use this unsupported parameter serves (maybe benchmarking?),
> but as you point out, not logging leaves the database open to all
> kinds of failure. It is certainly not to be used in any production
> situation.
>
> --
> Jeremiah Wilton http://www.wolfenet.com/~jeremiah

Regards

Pete

Received on Mon Jun 28 1999 - 10:56:38 CDT