My Oracle Support Banner

DBMS_STATS Not Running in Parallel When DEGREE=> Set and Table Contains User-Defined PL/SQL Function that Is Not Parallel Enabled (Doc ID 1911883.1)

Last updated on JULY 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

A SQL Analyze statement, coming from DBMS_STATS, has parallel hints and shows a parallel plan.  The plan contains the operation PX COORDINATOR FORCED SERIAL, which means the parallel plan is executing serially; this is causing performance problems.

 

Cause

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
Symptoms
Cause
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.