Multiple choice technology databases

How to resolve incomplete checkpoints in database?

  1. SHU IMMEDIATE

  2. ADDING MORE REDO LOGS

  3. BOTH A AND B

  4. NONE OF THE ABOVE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

"Checkpoint not complete" occurs in Oracle databases when the DBWR cannot write dirty blocks fast enough before the redo logs wrap around. Adding more redo log groups or increasing their size gives DBWR more time to complete checkpoints. SHUTDOWN IMMEDIATE does not resolve this runtime performance issue.

Keep practicing — related questions