Re: Archive Processes

sushil wrote:
> Thanks David....but i guess the real problem lies somewhere else as i
> dont think the number and size of the logs are too small.Its a banking
> system with a total of 8 redo log groups each of 500 MB.At peak load
> the time to fill a log file is hardly 2 minutes.So i intended to ask
> whether there is a hidden parameter somewhere to define the local and
> remote archive log processes so that both dont interfere with each
> other.something like
>
> _log_archive_proccess_LOCAL=2
> _log_archive_proccess_REMOTE=2
>
> The local arch process quitely archives its own logs and the remote
> arch process communicates with RFS in writing to standby.
>
> sushil

The size of your redo log files is PRECISELY the problem here, as a two-minute log switch interval is not sufficient time to allow writes to a standby AND keep up with such a transaction load on the local server. Your misguided attempt to control the PROCESSES is futile; control that which you CAN (your redo log size) and stop trying to change that which you cannot.

Increase the size of your redo logs so that you have far greater than two minutes between logfile switches at peak load and your problem WILL go away.

David Fitzjarrell Received on Thu Sep 01 2005 - 08:15:46 CDT