Adaptive Features or: How I Learned to Stop Worrying and Troubleshoot the Bomb [DOAG 2016]

Loading Map....

Date/Time
Date(s) - 16/11/2016
11:00 am - 11:45 am

Location
DOAG Konferenz 2016

Categories


Adaptive Dynamic Sampling, Adaptive Execution Plans, SQL Plan Directives: these new features are the new performance troublemakers when migrating databases from 11g to 12c. The optimizer uses them to seek for the perfect execution plan, but does it always succeed?
How to identify if an upgraded database starts suffering of aggressive dynamic sampling?
How to check if a query execution plan is the result of a SQL plan directive?
Is it better to disable these features completely or selectively just for a specific query?
Having a clear understanding of the new adaptive features is crucial for every DBA in order to achieve a successful upgrade to 12c.
This session will focus on the first steps required to quickly troubleshoot performance issues due to the adaptive features.

The following two tabs change content below.

Ludovico

Principal Product Manager at Oracle
Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Fleet Patching and Provisioning (FPP), MAA-optimized database lifecycle management, Cloud MAA and Online Reorganization.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.