Oracle Tuning Concepts Introduction

Lesson 1

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:

1. Use data blocks efficiently to improve I/O performance
2. Tune using the new Oracle Data Structures
3. Use the Data Dictionary to monitor performance
4. Define and use Oracle table and index partitions
5. Tune with Oracle indexes for optimal performance
6. Tune Oracle for Web Applications
7. Describe and implement tuning techniques for Distributed Databases
8. 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:

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.
2. SQL Monitor supports adaptive plans in the following ways:
   1. Indicates whether a plan is adaptive, and show its current status: resolving or resolved.
   2. 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.