Re: Tool to view archivelog contents

From: Nicolai Tufar <ntufar_at_gmail.com>
Date: Mon, 31 Jan 2005 10:53:08 +0200
Message-ID: <d8092939050131005349695217@mail.gmail.com>

On Mon, 31 Jan 2005 08:11:08 +0000, stephen booth <stephenbooth.uk_at_gmail.com> wrote:
> If you're talking about archive logs and not online logs (which Oracle
> is trying to update) then you should be able to use LogMiner to view
> the contents with no problems with the database up.

Okay, I will start learning it right now. But I wish there were a utility to just show how many DML operations were performed on each table in a defined time range.

> If you're suddenly generating lots of extra redo then the first thing
> that comes to mind is to check that your datafiles aren't in backup
> mode.

I checked it: none is in backup mode.

> Stephen

Nicolai

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 31 2005 - 03:55:48 CST