Date(s) - 16/11/2016
11:00 am - 11:45 am
DOAG Konferenz 2016
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.
Latest posts by Ludovico (see all)
- Oracle Grid Infrastructure 19c does not configure the local-mode automaton by default. How to add it? - June 13, 2019
- (unsupported) DST_UPGRADE_STATE is DATAPUMP(1) but no data pump jobs are running. How to fix? - April 30, 2019
- First draft of a Common Oracle Environment… for the Cloud Database (and not only) - April 16, 2019