在Oracle Database 19c中Query Optimizer有哪些新特性.pdfVIP

The Query Optimizer in Oracle Database 19c What’s New? Christian Antognini ChrisAntognini antognini.ch @ChrisAntognini • Senior principal consultant, trainer and partner at Trivadis • christian.antognini@ • Focus: get the most out of database engines • Logical and physical database design • Query optimizer • Application performance management • Author of Troubleshooting Oracle Performance (Apress 2008/14) • OakTable Network, Oracle ACE Director Agenda • All Environments • Reporting on Hint Usage • Execution Plan Comparison Refer to the Oracle • Online Statistics Gathering Enhancements Database SQL Tuning Guide • Enterprise Edition for technical information • Automatic Resolution of Plan Regressions about the new features • Enterprise Edition with Management Packs • Statistics Maintenance Enhancements • Real-Time SQL Monitoring for Developers The Database Licensing Information User Manual • Enterprise Edition on Exadata provides information about • Real-Time Statistics • High-Frequency Automatic Statistics Collection their availability • High-Frequency SPM Evolve Advisor Task • Quarantine for Runaway SQL Statements • Automatic Indexing Disclaimer • This presentation does not cover the query optimizer features that are specific to the Autonomous Database services All Environments Reporting on Hint Usage • It is an issue to verify whether hints added to SQL statements are actually used • To make it easier, there is a new sec