How to Achieve Parallel Statement Queuing for an SQL When PARALLEL_DEGREE_POLICY=MANUAL
(Doc ID 1902069.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle 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 |