Last updated on JUNE 30, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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
Million Knowledge Articles and hundreds of Community platforms