Re: Logging

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Sun, 27 Jun 1999 22:45:15 -0700
Message-ID: <Pine.OSF.4.02.9906272240300.14413-100000@gonzo.wolfenet.com>

> 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 Received on Mon Jun 28 1999 - 00:45:15 CDT