My Oracle Support Banner

How to Achieve Parallel Statement Queuing for an SQL When PARALLEL_DEGREE_POLICY=MANUAL (Doc ID 1902069.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document explains how you can achieve Parallel Statement Queuing for any SQL Statement with the PARALLEL_DEGREE_POLICY parameter set to MANUAL.

Note: The method given in this document is the ONLY SUPPORTED METHOD for getting a parallel statement to use the queue when parallel_degree_policy = manual.   You may also want to refer to <Document 1677076.1> "Hidden PX Parameters Should Be Used Only When Directed by Support or Development" if you are trying to use any other method.

 

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
 Example 1 - how to enable Automatic Degree as well as Parallel Statement Queuing
 Example 2 - how to enable Parallel Statement Queuing with manual DOP
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.