Changes in This Release for Oracle Database Performance Tuning Guide

This preface contains:

Changes in Oracle Database Release 23ai

The following are changes in Oracle Database Performance Tuning Guide for Oracle Database release 23ai.

New Features

The following features are new in this release:

  • AWR automatic snapshot collection for PDBs is now enabled by default. The default value for the AWR_PDB_AUTOFLUSH_ENABLED initialization parameter is TRUE instead of FALSE. Refer to Managing Automatic Workload Repository in a Multitenant Environment

  • AWR support for ADG Standby and True Cache Databases. AWR now supports creating CDB and PDB level snapshots for ADG Standby and True Cache databases. The Automatic AWR snapshot for these databases are enabled by default.

    This feature replaces the RMF Topology used in previous releases to support ADG Standby databases. RMF is no longer the recommended for capturing AWR data for ADG standby databases. Refer to Managing Automatic Workload Repository in Active Data Guard Standby Databases

  • ADDM Spotlight provides a visual representation of critical performance categories, rates the overall impact on system performance, and provides recommendations.

    Monitoring Databases with Performance Hub provides the ability to monitor database activity, diagnose issues, and tune queries to improve the performance of Oracle databases.

  • Enhanced Result Cache provides better scalability, better control of what is being cached, and broadens the applicability to cache results beyond the limits of pure-memory storage.

  • A new high-performance regular expression engine improves the performance of regular expression operators in SQL. The new regular expression engine is automatically enabled if the database configuration is supported, and if sufficient PGA memory is available.