Re: Unusual Log Switching

Eric,

Are the logs full? In other words, is the log switching occurring because of excessive redo generation.

Does the alert log indicate that perhaps a manual ALTER SYSTEM SWITCH LOGFILE occurred?

Is this an OPS environment (i.e. multiple threads)?

Does the log switching event occur at approximately the same time?

Rick

Eric Kimble wrote:

> 8.1.7.3.0 on NT 4 system. In looking at the Archived logs I have noticed
> a trend over the last few months. The system will usually switch about 3
> times a day ( not a really busy server) but about once a month the
> system will go into a hyperactive mode ( I don't have jobs scheduled
> during this time and it is not the same day each month) where it will
> switch 4-5 time per minute for about 2 hours. I was wondering if you all
> could maybe give me some ideas to check into. I've already looked at
> Scheduled jobs, I don't have individual users logged into this database
> ( it support a 3rd party app) and the use of the 3rd party app is used
> consistently and hasen't been reported from during those times. It of
> course isn't hurting the system any but I don't like it when things
> happen on the database and I don't know why.
>
> TIA
> Eric Kimble
Received on Wed Jul 31 2002 - 17:11:01 CDT