Do Not Use Parallel Query In ALTER TABLE MODIFY (column Not Null)
Last updated on JUNE 30, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
You are modifying table with mutli billion rows. Specific column was nullable and became not null
The time to change constraint takes around 40 minutes.
Mainly due to execution
SELECT /* all_rows ordered dynamic_sampling(2) */ A.rowid,:1,:2,:3 from "TCTDBS"."ARCHORIGINALPOS" A WHERE ( "COMAMOUNT" is NULL)
this query is running without parallelism
You specifically run
ALTER SESSION FORCE PARALLEL DML PARALLEL 8
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 8
ALTER SESSION FORCE PARALLEL DDL PARALLEL 8
But it still does not use parallelism
Any option to force parallelism?
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