Tuning Instance   «Prev  Next»

Overall redo log tuning - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. What redo log parameter will remedy high redo log space requests?
Please select the best answer.
  A. Log_small_entry_max_size
  B. Log_checkpoints_to_alert
  C. Log_buffer
  D. Log_simultaneous_copies

2. What is the best approach to sizing your online redo logs?
Please select the best answer.
  A. Size them to switch fewer than two times per hour
  B. Size them according to the number of redo log space requests
  C. Size them according to the value of redo buffer allocation retries
  D. Size them large enough to avoid "snapshot too old" errors

3. Which are sources of redo log tuning statistics? (Please select all that apply.)
Please select all the correct answers.
  A. The V$SYSSTAT view
  B. The V$LOG view
  C. The output from utlbstat-utlestat
  D. The output from an export-import

4. Which Oracle background processes are responsible for redo log activity? (Please select all that apply.)
Please select all the correct answers.
  A. PMON
  B. ARCH
  C. LGWR
  D. SMON