Wednesday Mar 01, 2017

Optimizer Adaptive Features and Upgrading to Oracle Database 12c Release 2

Introduction

Here's a reminder of the changes we’ve made to the optimizer’s adaptive feature settings in Oracle Database 12c Release 2. The new default behavior is covered in an earlier post but I want to cover the various options available to you depending on what you're upgrading from.

Here are the most common upgrade scenarios and for each I’m going to recommend what adaptive parameter settings to use.

[Read More]

New Optimizer Statistics White Paper

A new white paper on Oracle Optimizer statistics is now available. Just go to the Query Optimization page in OTN and click the Understanding Optimizer Statistics with Oracle Database 12c link.

Post comments to this blog if you want to give me feedback on the content.

Thanks!

About

The Oracle Optimizer blog is written by members of the Optimizer development team. The goal of this blog is to provide an insight into the workings of the Optimizer and the statistics it relies on. The views expressed on this blog are our own and do not necessarily reflect the views of Oracle and its affiliates. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect ours.

Search


Archives
« March 2017
SunMonTueWedThuFriSat
   
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today