Maricopa Community Colleges  CIS119DR   20016-20042 
Official Course Description: MCCCD Approval: 05/22/01
CIS119DR 20016-20042 L+L 3 Credit(s) 4 Period(s)
Oracle: Performance Tuning
Recognizing, troubleshooting, and resolving common performance related problems in administering an Oracle database. Includes an interactive workshop that will provide participants with the opportunity to walk through numerous real-world performance tuning case studies. Prerequisites: CIS119DP or permission of the instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS119DR   20016-20042 Oracle: Performance Tuning
1. Tune an Oracle database and resolve common performance related problems in administering an Oracle database. (I, II)
2. Use Oracle tools to diagnose specific performance problems. (I, II, III)
3. List the important steps for outlining a tuning methodology. (I, II)
4. Detect and resolve latch and lock contention problems within the Oracle database environment. (III)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS119DR   20016-20042 Oracle: Performance Tuning
    I. Oracle performance turning methodology
            a. The nature of tuning
            b. Oracle diagnostic tools
            c. Views, utilities, and files
            d. A tuning methodology
            e. The primary importance of SQL tuning
            f. Operating system related issues
            g. Tuning the Shared Pool memory structure, the Buffer Cache memory structure, and the Redolog Buffer memory structure
      II. Database configuration and I/O issues
              a. Space management and performance
              b. Diagnosing and resolving performance issues associated with the multi-threaded server
              c. Optimizing sort operations
              d. Configuring memory and disk resources to optimize sort operations
              e. Identifying and resolving I/O, data storage, and database configuration issues
        III. Tuning rollback segments
                a. Checking rollback segment performance
                b. Monitoring and detecting lock contention
                c. Latch contention and additional contention issues
                d. User connection and Network tuning
                e. Tuning with Oracle Expert
        Go to Description    Go to top of Competencies    Go to top of Outline