compatible parameter for 19c
Upgrading to 19c. from 12..1.0.2 for EBS and a data warehouse.
Do i set the compatible parameter to 19.0.0 or 19.10.0? The Jan CPU is applied to 19.0.0 which makes the version 19.10.0.
What about these parameters? I know anything after the 3rd digit is not necessary.
SQL> select name, value from v$parameter where value like '12.%'
NAME VALUE
------------------------------ --------------------
compatible 12.1.0.2.0
_compression_compatibility 12.1.0.2.0
optimizer_features_enable 12.1.0.2
_optimizer_undo_cost_change 12.1.0.2