Query Executes With Automatic DOP While Degree Of Parallelism Is 1 As Value
Last updated on FEBRUARY 02, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11 to 18.104.22.168 - Release: 11.2 to 11.2
Information in this document applies to any platform.
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'));
- dynamic sampling used for this statement (level=2)
- automatic DOP: Computed Degree of Parallelism is 1.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms