Re: INSIDE ARCHIVELOGS ?

From: R C <cord_at_mail.anonymizer.com>
Date: Fri, 19 Jan 2001 14:28:58 GMT
Message-ID: <1103_979914538@rcording>

In recent versions of 8i, you can use LogMiner to look at the contents of redo logs. I'm not sure in which version it first appeared, but it's definitely there in 8.1.6.

It's not a terribly complicated tool, but I'm not about to retype the one chapter long manual. Look in the Database Administrator's Guide.

Robert

On Tue, 16 Jan 2001 16:34:36 -0500, "Richard Sutherland" <rvsutherland_at_yahoo.com> wrote:
> Are you running hot backups during these hours? If so, this could account
> for it, especially if you have a large block size -- LGWR writes full blocks
> for activity on tablespaces that are in backup mode (even for changes to a
> single column in a single row).
>
> Richard Sutherland
> rvsutherland_at_yahoo.com
>
> tom <tompr_at_hotmail.com> wrote in message
> news:OpF86.670$TR6.24095_at_sodalite.nbnet.nb.ca...
> > Hi
> >
> > My DB is creating archive logs like crazy during the evening when
> > the usage is very low .
> >
> > I would like to see what is causing this.
> >
> > Is there a way that i can see what is inside thew archivelogs ?
> >
> > thanks
> > tom
> >
>
>
Received on Fri Jan 19 2001 - 08:28:58 CST