Increasing the number of redo logs seems to be most effective. Question
yourself what is happening in this case where the logs are switching every
half-minute. Is it something out of the ordinary? When I do a database
import, I get these messages down several pages. Oracle waits perfectly
well for the checkpoint to complete.
<celia9268_at_my-deja.com> wrote in message news:7m5orf$lbk$1_at_nnrp1.deja.com...
> Hi, the logfile is set to the size of 5000k. But sometimes switching
> happens every half hour or long.
> Thanks
>
> celia
>
> In article <7m5nsb$ktt$1_at_nnrp1.deja.com>,
> Denny Koovakattu <denny_vk_at_my-deja.com> wrote:
> > Hi,
> >
> > Your logs are sized too small. They are switching every minute. And
> > you have only two log groups. I would suggest increasing the size of
> > your log files and also to add at least one more log group. Since you
> > would not be able to drop any log group now, add the new log group
> with
> > the new size first before attempting to drop and recreate the existing
> > log groups.
> >
> > Regards,
> > Denny
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 09 1999 - 21:31:35 CDT
