RelationalDBDesign 





Tuning Instance   «Prev  Next»
Lesson 1

Introduction to Oracle 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.



Database Planning Tasks

Action Additional Information
Plan the database tables and indexes and estimate the amount of space they will require. Part II, "Oracle Database Structure and Storage" Part III, "Schema Objects"
Plan the layout of the underlying operating system files your database will comprise. Proper distribution of files can improve database performance dramatically by distributing the I/O during file access. You can distribute I/O in several ways when you install Oracle software and create your database.
For example, you can place redo log files on separate disks or use striping. You can situate datafiles to reduce contention. And you can control data density (number of rows to a data block). If you create a Flash Recovery Area, Oracle recommends that you place it on a storage device that is different from that of the datafiles.
Oracle Database Performance Tuning Guide Oracle Database Backup and Recovery User's Guide
Your Oracle operating system specific documentation, including the appropriate Oracle Database installation guide.
Consider using Oracle-managed files and Automatic Storage Management to create and manage the operating system files that make up your database storage. Oracle Database Storage Administrator's Guide
Select the global database name, which is the name and location of the database within the network structure. Create the global database name by setting both the DB_NAME and DB_DOMAIN initialization parameters. Determining the Global Database Name"