Skip to Main Content
SQL Performance Watch: Validate Database Changes Before Impacting Production Performance

About This Workshop

Youtube Video

About This Workshop
Learn how OCI SQL Performance Watch, a feature in the OCI Database Management service helps you predict and prevent SQL execution performance issues caused by environment changes. In this workshop, see how SQL Performance Watch provides you SQL execution plan statistics insights and impacts caused by an environment or configuration change so they can be corrected before impacting business. By running SQL statements serially before and after changes, SQL Performance Watch generates a comprehensive report for you. The report outlines the net impact on the workload resulting from the system change and identifies any regressed SQL statements. For regressed SQL statements, OCI SQL Performance Watch provides detailed execution plan insights and recommendations for their optimization. Understand why SQL Performance Watch is something every Developer, DBA, DevOps and IT team should be using.

Workshop Info

30 minutes
  • Obtain an overview of your database fleet
  • View reports created by SQL Performance Watch that provide performance insight into the overall health of your databases
  • Learn how to create the SQL Performance Watch task
  • Review a report of database upgrade from v19.3 to v19.26
  • See how to proactively review the impact of adding a new index on an database by assessing the saved SPA report
     
  • Familiarity with Oracle Database and SQL is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like