Query Executes With Automatic DOP While Degree Of Parallelism Is 1 As Value (Doc ID 1341407.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 to 11.2.0.2 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

While running a query with DOP 2, then it runs with DOP 1.

For example:

create tablespace tbs_test datafile 'abc' size 2G autoextend on;
grant dba to bug identified by bug.
create table test2 tablespace tbs_test as select * from dba_extents;
alter session set parallel_degree_policy='AUTO';
explain plan for
select count(*) from test2 a, test2 b;
select * from table (dbms_xplan.display(NULL,NULL,'ADVANCED'));

Note
-----
- dynamic sampling used for this statement (level=2)
- automatic DOP: Computed Degree of Parallelism is 1.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms