RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
  Course navigation
Lesson 1
Redo log tuning
    In the previous modules, we examined tuning the shared pool and the Oracle data buffer cache. This module discusses Oracle's redo logs and why the redo log is an integral part of the Oracle engine and provides several tuning opportunities that improve Oracle performance.
By the time you complete this module, you should be able to:
  1. Understand redo log functions
  2. Describe the main tuning techniques for the redo log
  3. Investigate redo log activity for Oracle tasks
  4. Set the redo log parameters
  5. Examine redo log wait statistics
  6. Determine sizes for online redo logs
  7. Set appropriate sizes for the archived redo log file system
  8. Change parameters to relieve redo log contention
  9. Set log_checkpoint_interval to maximize performance
In the next lesson, we will begin our overview of the redo log.
  Course navigation