2 Replies Latest reply: Apr 17, 2013 10:01 AM by saratpvv RSS

    FAL & LOG_ARCHIVE_MAX_PROCESS

    1002021
      Hello,

      For FAL Gap resolution, Does increasing LOG_ARCHIVE_MAX_PROCESS at the primary fasten up the redo transport process?

      Thanks
        • 1. Re: FAL & LOG_ARCHIVE_MAX_PROCESS
          Sunny kichloo
          Refer this link

          http://blog.nominet.org.uk/tech/2008/01/03/be-careful-when-setting-log_archive_max_processes/
          • 2. Re: FAL & LOG_ARCHIVE_MAX_PROCESS
            saratpvv
            For FAL Gap resolution, Does increasing LOG_ARCHIVE_MAX_PROCESS at the primary fasten up the redo transport process?
            The number of ARCn processes should be defined based on the number of log files and database workload. For example, .The Default value is 2.
            Increasing the log_archive_max_processes to resolve archive log gaps is one of the common requirement and this must not be done if you do not have sufficient network band width. In those cases you might end up with negative results.