My Oracle Support Banner

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 04, 2018

Applies to:

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


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.



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

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