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 configuration items most directly control redo/archivelog storage behavior and capacity? (Please select all that apply.)
Please select all the correct answers.
  A. Online redo log size (log group member size)
  B. Number of redo log groups (enough to prevent reuse waits)
  C. FRA configuration: DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE
  D. Archive destination configuration (for example LOG_ARCHIVE_DEST_1)

2. What is the best practical criterion for sizing online redo logs in many OLTP systems?
Please select the best answer.
  A. Size redo logs to achieve log switches roughly every 15–30 minutes during peak workload
  B. Size redo logs so that you switch fewer than three times per day
  C. Size redo logs to hold at least 24 hours of redo activity per log file
  D. Size redo logs based only on the number of tablespaces in the database

3. Where are the best places to find evidence of redo log switch frequency? (Please select all that apply.)
Please select all the correct answers.
  A. The alert log (log switch / checkpoint related messages)
  B. The V$LOG_HISTORY (or GV$LOG_HISTORY) view
  C. Archived log listings (for example, RMAN LIST ARCHIVELOG output or filesystem timestamps)
  D. The V$SYSSTAT view (directly reports log switch count per hour)




RedoLog Tuning Concepts