Lesson 1
Course introduction Advanced Oracle Tuning Concepts
This course is the last in the five-part Oracle8 Performance Tuning Certification Series. This course introduces you to some advanced
Oracle performance tuning tools and concepts associated with Oracle8TM. This is the final in a five-part series that is designed to give you
the skills to maximize the performance of your Oracle database.
If you've completed the other four parts in our five-part series, you're well on your way to understanding the finer nuances of Oracle performance tuning. In this course, you will have the opportunity via hands-on exercises to look into the more subtle elements of the Oracle engine, and the more advanced features of Oracle tuning.
Course goals
If you've completed the other four parts in our five-part series, you're well on your way to understanding the finer nuances of Oracle performance tuning. In this course, you will have the opportunity via hands-on exercises to look into the more subtle elements of the Oracle engine, and the more advanced features of Oracle tuning.
After completing the course, you will be able to:
Presentation Techniques
- 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)
In this course, you will learn and practice Oracle tuning concepts with two kinds of simulations:
the MouseOver, the SlideShow.
The series
the MouseOver, the SlideShow.
Advanced Oracle Tuning Concepts is the last of five courses in the Oracle8 Performance and Tuning Certification Series.
In the next lesson, you will learn about the prerequisites for our Advanced Oracle Tuning Concepts course.
In the next lesson, you will learn about the prerequisites for our Advanced Oracle Tuning Concepts course.