My Oracle Support Banner

Why Is the Sql Running in Parallel? (Doc ID 1627599.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Goal

What is the reason for which a statement is executed in parallel even so all the conditions of having this in serial are met?

The degree for all the tables involved is set to 1

and

parallel_degree_limit      CPU         
parallel_degree_policy     MANUAL

Much more even when setting:

ALTER SESSION DISABLE PARALLEL DML;
ALTER SESSION DISABLE PARALLEL DDL;
ALTER SESSION DISABLE PARALLEL QUERY;


the statement is still executed in parallel.
 

Solution

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
Goal
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.