Database Administration (MOSC)

MOSC Banner

Online redefinition of table with multiple CLOB columns not executing in parallel 19c

edited May 2, 2023 4:43PM in Database Administration (MOSC) 16 commentsAnswered

"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - 

Production Version 19.15.0.0.0"

The table with 3 CLOB columns is not executing in parallel during START_REDEF_TABLE stage of online redefinition. The source table is range partitioned using MAXVALUE and the destination table is range-interval partitioned.

The migration process is using DBMS_REDEFINITION and following parallel settings have been set at session level before executing the redefinition:

ALTER SESSION FORCE PARALLEL DML PARALLEL 8 ;

ALTER SESSION FORCE PARALLEL QUERY PARALLEL 8 ;

 v$session parallel values mentioned below

PDML_STATUS: FORCED

PDDL_STATUS: ENABLED

PQ_STATUS: FORCED

If DBMS_REDEFINITION is executed with another table that contains 1 CLOB column, then parallelism works fine.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center