Set only one archive dest but defined as 10 destinations can be enabled for archive logs.looks normal,as by default log_archive_dest_state_* are enabled.
As we are facing slowness when logswitch occurs and log_archive_max_processes are set to 4.whats the size of your redolog...and any special AWT top wait event during slowness.
955685 wrote:yes and you've already setup one destination log_archive_dest_state_1 which is ok.
Enabled 10 archive destinations but set only one path for archive log files to be created by log_archive_dest_state_1 = "LOCATION=/u03/PROD/Archive"
I think if i want to define only one archive destination, log_archive_dest is enough right..? correct me if i'm wrong.
Any difference between log_archive_dest_state_1 and log_archive_dest?For Enterprise Edition users, LOG_ARCHIVE_DEST parameter has been deprecated in favor of the LOG_ARCHIVE_DEST_n parameters.
And there are 8 redo log goups and log_archive_max_processes=4, is it causing slowness because of less archive_processes..?not really required ,
Can we increase it to 8 instead of 4.