Table-level PARALLEL hint may give wrong DOP or ORA-12850 without fix for Bug 21612531; ORA-7445 in kkfdDegreeLimit() with fix present (Doc ID 2286868.1)

Last updated on AUGUST 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

A table-level PARALLEL hint takes the following form:

/*+ parallel(<table>,<degree>) */  -- where <table> is the table name, and <degree> is the desired degree of parallelism (DOP)

 

Before applying the fix for unpublished BUG 21612531 - "MV: CREATE MV REPORTS ORA-12850 IN ALERT LOG," you may see the following when PARALLEL_DEGREE_POLICY = AUTO:

After applying the fix for unpublished BUG 21612531 you may see the following internal error:

 

Note: Although the title of unpublished Bug 21612531 mentions materialized views, they are not necessary to hit this bug.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms