SQL Tuning Tips for Cloud Administrators (OpenWorld 2019: CON5145)
SummarySQL Tuning Tips for Cloud Administrators (OpenWorld 2019: CON5145)
While autonomous databases automate provisioning, system tuning of the 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 for tuning an application workload on an on-premise database and migrating it to an autonomous database with minimal risk.