My Oracle Support Banner

AutoDOP Seems to Ignore Object-level Parallel Hints (Doc ID 1502256.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

Simple select statements with a parallel hints are run in an 11.2 database with AutoDOP configured.   The statements run either serially or with a DOP different from the one specified, leading one to believe that object-level hints are ignored when AutoDOP is configured.

Here are two simple select statements:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
 Case 1:  Statement runs serially
  Case 2:  Statement runs with a DOP different from the one specified (parallel hint specified 10; AutoDOP uses 14)
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.