Re: Oracle archive redo log question

From: Paul Drake <paled_at_home.com>
Date: Sat, 12 May 2001 15:21:29 GMT
Message-ID: <3AFD54F8.A61753F8@home.com>

angry_garden_salad_at_yahoo.com wrote:
>
> HI,
> What the heck is in these archive redo logs
> anyway? A bunch of overhead junk? I thought the redo log switch did not happen
> until the redo log filled up. Doesn't say inserting 100M of data into a
> database produce 100M of redo log information? Or does 100M of inserts produce
> 1 GB of redo log information. Is there a parameter I have messed up somewhere?
> I'm not having any database problems, but it looks like I'm just gonna need a
> lot of tapes. thanks in advance....

fire up LogMiner, and look at the archived redo log contents for yourself.
You can even use it on a non-production database to examine logs from your production db.

have fun.

Paul Received on Sat May 12 2001 - 10:21:29 CDT