Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: redo logs: instantaneous switches
I just went with the default sizes. It's a POS database, with
six or eight registers. Average is a switch every 30 minutes,
which at the time I deployed seemed reasonable according to
advice and research available at the time. Guess not.
This "log miner" is something new to me. I'll look into it, unless you mean reading the alert log for switching info, in which case I included snips in my original message.
Good to see you again, Howard! I still miss your website. It was invaluable to me. Sure glad I made hard copies.
D.
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:
>
>Not really, other than that your redo logs at only 1MB big are
>way, way too
>small.
>
>But that should make it really easy to use log miner to find
>out what was in
>the log when it was switching rapidly.
>
>Regards
>HJR
>
>
Received on Thu Jan 23 2003 - 14:46:44 CST