Changes in This Release for Oracle Database Performance Tuning Guide

In-Memory Column Store

The In-Memory Column Store (IM column store) is an optional area of the SGA that stores copies of tables, partitions, and other database objects in a columnar format that is optimized for rapid scans. IM column store accelerates database performance of analytics, data warehousing, and online transaction processing (OLTP) applications.

See "Configuring the In-Memory Column Store".

Manageability support for In-Memory Column Store

SQL Monitor report, ASH report, and AWR report now show statistics for various in-memory operations.

Force full database caching mode

Force full database caching mode enables you to cache the entire database in memory, which may provide substantial performance improvements when performing full table scans or accessing LOBs.

See "Configuring the Database Caching Mode".

Real-Time ADDM

Real-Time ADDM helps you to analyze and resolve problems in unresponsive or hung databases without having to restart the database.

See "Real-Time ADDM Analysis".

Limiting the size of the Program Global Area (PGA)

The PGA_AGGREGATE_LIMIT initialization parameter enables you to specify a hard limit on PGA memory usage. Oracle Database ensures that the PGA size does not exceed this limit by terminating sessions or processes that are consuming the most PGA memory.

See "Limiting the Size of the Program Global Area".

New books

Oracle Database Performance Tuning Guide is undergoing a major rewrite for this release. As a result, the book structure has undergone significant changes. This book now contains only tuning topics that pertain to the database itself. All SQL-related tuning topics are moved to Oracle Database SQL Tuning Guide.