Re: Deactivating Redo Logs on 9i?

From: Edzard <edzard_at_volcanomail.com>
Date: 27 Feb 2002 11:41:08 -0800
Message-ID: <5d75e934.0202271141.cb5df6b@posting.google.com>

Hello,

Have a look at this extract from the alert log:

Wed Feb 27 15:06:14 2002
Starting up ORACLE RDBMS Version: 9.0.1.2.0. System parameters with non-default values:
..

  _disable_logging = TRUE
..

  Current log# 1 seq# 28 mem# 0: /u01/oracle/p1/oradata/redo01.ln
..

Wed Feb 27 15:27:59 2002
Thread 1 advanced to log sequence 29
  Current log# 2 seq# 29 mem# 0: /u01/oracle/p1/oradata/redo02.ln

What I was doing at the time is measuring the effect on the wait time of a data processing job:
Whithout _disable_logging: Elapsed: 00:04:22.52 Whith _disable_logging: Elapsed: 00:04:24.05

Has anyone else measured this, I mean that it makes no difference? May be it is only like this since Oracle9i.

Edzard Received on Wed Feb 27 2002 - 13:41:08 CST