Lesson 1
New Features for Performance Tuning Oracle
This course introduces you to the newest features introduced in Oracle9i, which is designed to help you get better database performance.
This course covers improvements in Oracle8i for indexes, queries, and the query optimizer; the use of index-organized tables; and a special feature called Advanced Queuing. In addition, Oracle8i includes a new feature called materialized views that can significantly improve the performance of some queries, such as data warehouse summary queries.
This is the third course in the five-part Oracle8i New Features Certification Series. Taken in conjunction with the other courses within this series, this course will prepare you to pass the Oracle8i New Features for Administrators certification exam. Along the way, you will work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.
Course goals
This course covers improvements in Oracle8i for indexes, queries, and the query optimizer; the use of index-organized tables; and a special feature called Advanced Queuing. In addition, Oracle8i includes a new feature called materialized views that can significantly improve the performance of some queries, such as data warehouse summary queries.
This is the third course in the five-part Oracle8i New Features Certification Series. Taken in conjunction with the other courses within this series, this course will prepare you to pass the Oracle8i New Features for Administrators certification exam. Along the way, you will work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.
After completing the course, you will be able to:
Learning Methodologies
- Understand and use enhancements to the cost-based optimizer
- Use stored outlines for queries
- Use the procedures in the DBMS_STATS package for optimizing query performance
- Use materialized views
- Use reverse indexing, descending indexes, domain, and function-based indexes
- Use the new index maintenance features in Oracle8i
- Understand the enhancements for index-organized tables, such as secondary indexes and rebuilding index-organized tables while leaving the tables available online
- Use Advanced Queueing in an application
- Understand the new features for Large Objects (LOBs), such as temporary LOBs and client-side buffering of LOBs
In this course, you will learn and practice your skills with two kinds of widgets:
The series
- the SlideShow and
- the MouseOver.
New Features for Performance Tuning is the third of five courses in the Oracle8i New Features
Certification Series .
If you are interested in finding out which Oracle courses you should take to help you achieve your learning goals, try our SkillPlanner Maps.
In the next lesson, you will learn about the prerequisites for this course.
If you are interested in finding out which Oracle courses you should take to help you achieve your learning goals, try our SkillPlanner Maps.
In the next lesson, you will learn about the prerequisites for this course.
