Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

About the log file switch and the checkpoint

In our database, sometimes we will see that all redo log groups are active. At this time, we think that there may be no logs to write, and the checkpoint has not been completed. However, as the current log group need to switch, the next log group that was originally active can immediately become inactive then current. It seems that this checkpoint can be completed immediately. This often troubles us, because this is not an abnormal redo log group. Insufficient, too busy to write dirty blocks, the checkpoint cannot be completed.
So we want to know how we can accurately monitor whether redo is really insufficient?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center