My Oracle Support Banner

How to View Why the Degree Of Parallelism (DOP) was Downgraded for an SQL in 12c (Doc ID 2011375.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 22-Jun-2018 ***

Goal

How to view the reason for the degree of parallelism (DOP) downgrade for a parallel query/sql.

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
 SQL Monitor HTML output / corresponding EM page
 Querying SQL Monitor information
 PX trace
References

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