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 isTRUE
instead ofFALSE
. 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.
Note:
See Setting the Result Cache Mode -
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.