Skip to Main Content

SQL Watch - Guard your Oracle Database 23ai upgrade against SQL performance regressions

SQL Watch is a new capability in Database Management cloud service that enables automated and accurate change impact assessment of system changes such as database upgrades, patch sets, migrations, minor application upgrades, add/drop index or routine refresh of optimizer statistics.

  • SQL Watch is designed to predict and prevent SQL execution performance issues caused by above such changes.
  • By running SQL statements before and after the change with real production context, it generates a comprehensive report that outlines the net impact on the workload resulting from the change and identifies any regressed SQL statements.
  • For these regressed SQL statements, SQL Watch offers detailed execution plan insights as well as proactive recommendations to remediate them. 

 

This session will cover various SQL Watch use cases such as Oracle Database 23ai upgrade, parameter changes, etc., and associated best practices that will guard your databases against SQL performance regression

Featured Speakers

  • Speaker

    KATHRYN JENNINGS


    Senior Principal Product Manager

  • Speaker

    Anusha Vojjola


    Senior Product Manager

Workshop Info

Session Has Completed - 06 August 2024
1 Hour
English
Real Application Testing, Database Cloud Management, Database Management

Other Upcoming Sessions