Hi there,

Could anyone shed any light on why the logs in my Oracle7.3.3 database are switching far more than normal.

We are running Peoplesoft against this database so all transactions are controlled through this, I have checked the processes scheduler and no abnormal jobs are running.

The logs are 7 groups 2 members each 40 M, they are switching roughly every 10 to 30 seconds (this is very unusual).

Is there something I should be looking at to discover what's going on.

We are running in archive log mode and this switching is eating up all the space on the server (so much so that the archiver process is stopping when we run out of space).

Any help would be greatly appreciated.

Alison