Query on Redo Log Group (Doc ID 1564576.1)

Last updated on MAY 05, 2016

Applies to:

Oracle Communications ASAP - Version 7.0.0 and later
Information in this document applies to any platform.

Goal

An issue of "log file switch (checkpoint incomplete)" was faced in one of a customers production database servers. The DBA team at the customer end has recommended to increase the Redo Log Groups from current 3 (1 GB each) to 5 (1 GB each). The LOG BUFFER size is currently 14 MB, which will remain the same. Database Version used is 10G R2.

What is the impact - both positive and negative will this have on ASAP 7.0.0 performance?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms