ALTER TABLE ADD Column With DEFAULT Values Turn To Updates Due To Disabled VPD Policy (Doc ID 2708625.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Symptoms

An ALTER TABLE ADD column with DEFAULT values is turning to update commands for each row due to disabled VPD policy with statement_type = update

Alter table add column optimizes only when the table does not have a VPD policy. But even when the policy is disabled, we do not see the optimizations.

Cause

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