Re: INSIDE ARCHIVELOGS ?

From: David Fitzjarrell <oratune_at_aol.com>
Date: Mon, 15 Jan 2001 17:34:14 GMT
Message-ID: <93vcal$o2j$1@nnrp1.deja.com>

In our last gripping episode tompr_at_hotmail.com (tom) wrote:
> 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
>
>

If you are running 8i (8.1.5 or higher) you should have access to LOGMINER. You will most likely need to install it in your instance; the scripts are in $ORACLE_HOME/rdbms/admin.

Once installed read through the documentation. You should find this utility quite useful for examining redo logs and archived redo logs.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/

Received on Mon Jan 15 2001 - 11:34:14 CST