Re: Redo Log Space ??

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 18 Jun 1999 08:56:45 +0100
Message-ID: <929693745.29967.0.nnrp-13.9e984b29@news.demon.co.uk>

Yes and no.

It is one of the parameters set when the database is created (MAXLOGHISTORY),
and seems to default on some versions
to 64000 !

When it hits the limit it recycles.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Erik wrote in message <7kbnnu$uj3$1_at_nnrp1.deja.com>...
>(By the way, I have over 57,000 record in my v$log_history from a large
>update that we ran and the log was switching every second or so. Does
>the v$log_history ever get cleared out?)
Received on Fri Jun 18 1999 - 02:56:45 CDT