Sun Microsystems, Inc.
spacer spacer
spacer   Sun Educational Services  
spacer
black dot
  black fade
spacer
  Course Catalog
logo

Advanced Oracle Tuning Concepts

( WT-1264-180 )


     Course DescriptionBack To Top

Course Offered in Partnership With DigitalThink

This course introduces students to advanced Oracle performance tuning tools and concepts associated with Oracle8, and is designed to give students the skills to maximize the performance of their Oracle database.

In conjunction with the other four courses in the Oracle8 Performance Tuning Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-014, Oracle8: Performance Tuning, part of the Oracle8 DBA certification track.

This course requires a computer running either Windows, Macintosh, or UNIX.

eMentoring Services are included with this course.

  • Course length:

    • Course details
        id:      WT-1264-180
        subscription duration:  180 days
        list price:  $  325.00


     
         Languages Offered Back To Top

    This course is currently available in English only.

     
         Prerequisites Back To Top

    To succeed fully in this course, students should be able to:

  • Demonstrate completion of Performance Tuning Basics, Tuning the Oracle Instance, Tuning Oracle SQL, and Tuning the External Oracle Environment or equivalent knowledge and experience.

    •  
         Skills Gained Back To Top

    Upon completion of this course, you should be able to:

  • Use data blocks efficiently to improve I/O performance
  • Tune using the new Oracle8 Data Structures
  • Use the Data Dictionary to monitor performance
  • Define and use Oracle8 table and index partitions
  • Tune with Oracle8 indexes for optimal performance
  • Tune Oracle8 for web applications
  • Describe and implement tuning techniques for Distributed Databases
  • Tune the Oracle Parallel Server (OPS)

    •  
         Related Courses Back To Top

  • Before: Performance Tuning Basics
  • Before: Tuning the Oracle Instance
  • Before: Tuning Oracle SQL
  • Before: Tuning the External Oracle Environment

    •  
         Course Content Back To Top



    Module 1: Course introduction Back To Top

  • Course introduction
  • Prerequisites
  • What you need
  • Course resources
  • Your e-learning community
  • Meet your instructor


    • Module 2: Using Oracle blocks efficiently Back To Top

  • Using Oracle blocks efficiently
  • Determining an appropriate database block size
  • Optimizing space usage within blocks
  • Internals of the Oracle segment header
  • Setting PCTFREE for optimal performance
  • Setting PCTUSED for optimal performance
  • Monitoring and tuning Oracle indexes
  • Table high water marks and full-table scans
  • Module wrap-up


    • Module 3: Tuning with Oracle8 data structures Back To Top

  • Tuning with Oracle8 data structures
  • Overview of Oracle8 data structures
  • Abstract data types
  • Navigating with object IDs (OIDs)
  • Using nested tables
  • Using VARRAYs in tables
  • Module Wrap-up


    • Module 4: Using the Oracle Data Dictionary to monitor performance Back To Top

  • Using the Oracle Data Dictionary to monitor performance
  • The Oracle performance views
  • Customizing DBA performance queries
  • Building a quick Oracle alert monitor
  • Module wrap-up


    • Module 5: Tuning with Oracle8 partitioning Back To Top

  • Tuning with Oracle8 partitioning
  • Overview of partitioning
  • DBA Views for Partitioned Objects
  • Global index partitioning
  • Local partitioned Indexes
  • Partitioned index maintenance
  • Module wrap-up


    • Module 6: Advanced techniques with Oracle indexes Back To Top

  • Advanced techniques with Oracle indexes
  • Bitmapped indexes
  • STAR index queries
  • STAR transformation queries
  • Using concatenated indexes
  • Function-based indexes
  • Module wrap-up


    • Module 7: Tuning Oracle for web applications Back To Top

  • Tuning Oracle for web applications
  • Overview of Oracle applications on the web
  • Using a Web Request Broker (WRB)
  • Tuning tips for web-based Oracle connectivity
  • Designing web applications for high performance
  • Managing concurrency for web applications
  • Alternative concurrency mechanisms for web applications
  • Module wrap-up


    • Module 8: Tuning distributed Oracle databases Back To Top

  • Tuning distributed Oracle databases
  • Tuning Oracle replication
  • Tuning with snapshots
  • Tuning database links
  • Tuning network traffic
  • Tuning two-phase commits
  • Module wrap-up


    • Module 9: Tuning for Oracle Parallel Server (OPS) Back To Top

  • Tuning for Oracle Parallel Server (OPS)
  • Overview of the OPS architecture
  • Raw devices and OPS
  • Understanding the Distributed Lock Manager (DLM)
  • Partitioning Oracle instances
  • Configuring the DLM
  • Understanding lock element cleanups in OPS
  • Module wrap-up


    • Module 10: Course conclusion Back To Top

  • Course conclusion
  • We'd love your feedback
  • Course survey


    • Terms of Use.  Privacy Policy.  Feedback.  Copyright 1994-2002 Sun Microsystems, Inc.