Tuning Overview 

    List the roles associated with 
       the database tuning process

    Define the steps associated 
       with the tuning process

    Identify tuning goals

Oracle Alert and Trace Files

    Describe the location and 
       usefulness of the Alert log 
       file

    Describe the location and 
       usefulness of the background 
       and user process trace files

Utilities and Dynamic 
Performance Views

    Collect statistics through: 
       -  Available dynamic 
           troubleshooting and 
           performance views 
       -  The UTLBSTAT/
          UTLESTAT report output 
       -  Oracle wait events 
       -  Appropriate Enterprise 
          Manager (EM) tuning tools

    Define the latch types

Tuning the Buffer Cache

    Describe how the buffer 
       cache is managed

    Calculate and tune the buffer 
       cache hit ratio

    Tune the buffer cache hit ratio
       by adding or removing buffers

    Create multiple buffer pools

    Size multiple pools

    Monitor buffer cache usage

    Make appropriate use of 
       table caching

    Diagnose LRU latch 
       contention

    Avoid free list contention

Tuning the Redo Log Buffer

    Determine if processes 
       are waiting for space in the
       redo log buffer

    Size the redo log buffer 
       appropriately

    Reduce redo operations

Database Configuration and 
I/O Issues

    Diagnose inappropriate use 
       of SYSTEM, RBS, TEMP, 
       DATA, and INDEX tablespaces

    Use locally managed tablespaces
       to avoid space management 
       issues

    Detect I/O problems

    Ensure that files are distributed
       to minimize I/O contention 
       and use appropriate type of 
       devices

    Use striping where appropriate

    Tune checkpoints

    Tune DBWn process I/O

Optimizing Sort Operations

    Identify the SQL operations 
       that require sorting

    Ensure that sorting is done 
       in memory where possible

    Reduce the number of I/Os
       required for the sort runs

    Allocate temporary space 
       appropriately

Tuning Rollback Segments

    Use the dynamic performance 
       views to check rollback 
       segment performance

    Reconfigure and monitor
       rollback segments

    Define the number and sizes 
       of rollback segments

    Appropriately allocate rollback 
       segments to transactions

   Managing a Mixed Workload

    Describe the features of 
       Database Resource Manager

    Limit the use of resources 
       using Database Resource 
       Manager

Multithreaded Server Tuning 
Issues

    Identify issues associated 
       with managing users in a 
       multithreaded server 
       environment

    Diagnose and resolve 
       performance issues with 
       multithreaded server processes

    Configure the multithreaded 
       server environment to 
       optimize performance