SQL Tuning Tips for Cloud Administrators
SummaryOracle OpenWorld 2018 | Systems Management Session PRO4377
While autonomous databases automate provisioning, system tuning of infrastructure, and backup/recovery tasks, a DBA still needs to diagnose application performance issues and tune the SQL issued from the applications. This session covers the methodology and toolkit consisting of SQL Tuning Advisor, SQL profiles, and SQL Performance Analyzer for tuning SQL to optimize application performance and improve quality of service. The session also covers how to use the recommended methodology and toolkit for tuning an application workload on an on-premises database and migrating it to an autonomous database with minimal risk.