Tuning Instance   «Prev  Next»

Redo log Tuning Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which are the most important redo log parameters? (Please select all that apply.)
Please select all the correct answers.
  A. Log_buffer
  B. Log_simultaneous_copies
  C. Log_small_entry_max_size
  D. Log_checkpoints_to_alert

2. Which is the best criterion for sizing the online redo log?
Please select all the correct answers.
  A. Sized for fewer than three log switches per hour
  B. Sized to hold at least two hours of redo activity
  C. Sized to allow one day's roll-forward capability
  D. Sized to keep more than one day's update activity

3. Where are the best places to find the frequency of redo log switches? (Please select all that apply.)
Please select all the correct answers.
  A. The alert log
  B. The V$SYSSTAT view
  C. The dates on the archived redo logs
  D. The V$LOGHIST view