This course introduces you to some advanced Oracle performance tuning tools and concepts associated with Oracle.
This course is designed to give you the skills needed to maximize the performance of your Oracle database.
In this course, you will have the opportunity by means of 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:
Use data blocks efficiently to improve I/O performance
Tune using the new Oracle Data Structures
Use the Data Dictionary to monitor performance
Define and use Oracle table and index partitions
Tune with Oracle indexes for optimal performance
Tune Oracle 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 following features are new in Oracle 12 Release 1:
- In-memory aggregation: This optimization minimizes the join and GROUP BY processing required for each row when joining a single large table to multiple small tables, as in a star schema.
VECTOR GROUP BY aggregation uses the infrastructure related to parallel query (PQ) processing, and blends it with CPU-efficient algorithms to maximize the performance and effectiveness
of the initial aggregation performed before redistributing fact data.
- SQL Monitor supports adaptive plans in the following ways:
- Indicates whether a plan is adaptive, and show its current status: resolving or resolved.
- Provides a list that enables you to select the current, full, or final plans
In the next lesson, you will learn about the prerequisites for our Advanced Oracle Tuning Concepts course.