Tuning Oracle Instance Prerequisites

In order to get the most from this course you should have a basic understanding of the UNIX operating system, PL/SQL coding techniques, and the following Oracle database concepts:

1. Oracle tables and tablespaces
2. Oracle instances
3. Oracle data dictionary

·
If you do not feel comfortable with one or more of these topics, techniques, or procedures, you may want to consider taking the course Basic SQL and Database Creation Architecture.
In the next lesson, we will outline what you need in order to realize the full potential of this course.

The new and updated performance tuning features include:

1. Dynamic statistics enhancements

In previous releases, Oracle Database only gathered dynamic statistics (previously called dynamic sampling) when one or more of the tables in a query did not have optimizer statistics.
Starting in Oracle Database 11g Release 2 (11.2.0.4), the optimizer can automatically decide whether dynamic statistics are useful and which dynamic statistics level to use for all SQL statements. For example, the optimizer automatically decides whether to gather dynamic statistics during

1. table scans,
2. index access,
3. joins, and
4. GROUP BY operations.

The enhanced behavior is enabled only when the OPTIMIZER_DYNAMIC_SAMPLING initialization parameter is set to the new value of 11.