Title

Real-time SQL Plan Management

About Or Title

About This Workshop

Desc Long

SQL execution plan changes can sometimes cause performance regressions that have a significant impact on the service levels of an application. Real-time SQL plan management will compare the performance of a new execution plan with the performance of plans previously used (within the last 53 weeks). If an earlier plan is known to perform significantly better, it will be reinstated automatically using a SQL plan baseline.

Workshop Length

48 minutes

Outline

Create a simple database schema
Execute an application query
Induce a performance problem with the query so it now performs poorly
Execute the query again and show that the performance issue has been resolved without any manual intervention
Repeat this test, but use database resource manager to stop the runaway query and allow real-time SPM to resolve the problem.

Prerequisites

Some familiarity with SQL plan management is required
Some understanding of cloud and database terms is helpful
Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like

Load and update Moviestream data in Oracle ADW using Data Studio

Load and update Moviestream data in Oracle ADW using Data Studio

Get to know the Autonomous Data Warehouse - Learn loading data using Data Studio.

1 hr 30021 Views
Manage and Monitor Autonomous Database

Manage and Monitor Autonomous Database

Provision an Oracle Autonomous Database and perform basic monitoring and management tasks.

3 hrs 65959 Views
Automatic Indexing for Oracle Autonomous Database

Automatic Indexing for Oracle Autonomous Database

The Oracle Autonomous Database can manage indexes without the need for manual intervention.

1 hr 3061 Views
No More SQL: Talk to the Database with OCI Digital Assistant

No More SQL: Talk to the Database with OCI Digital Assistant

This Lab will show users how to create a conversational interface on top of a database with the (..)

1 hr 2815 Views