Re: Temporary Workspace and Archive Logs

From: Paul Drake <paled_at_home.com>
Date: Thu, 26 Jul 2001 06:08:40 GMT
Message-ID: <3B5FB325.3B973767@home.com>

Jim wrote:
>
> My archive logs are 100MB, usually switching about 1 time every 2 days.
> When I run this report my archive logs switch about every 4 min while the
> report is running..
>
> Thanks in advance
>
> Jim McCraw

Jim,

You might want to consider setting up a dbms_job to switch your logfiles more frequently.
I would not recommend having 2 days worth of redo in one redolog file. General opinion that I have boserved would indicate that a redo log switch every hour would most likely balance the overhead of log switches (checkpoint) against the loss of data should the online redo log become unavailble.

just a thought.

Paul Received on Thu Jul 26 2001 - 01:08:40 CDT