params_diff.sql

create table params_12_1_0_2
as
select par.ksppinm  name,
       val.ksppstvl value,
       val.ksppstdf def_val
from   x$ksppi  par,
       x$ksppcv val
where  par.indx=val.indx;

alter session set optimizer_features_enable='12.1.0.1';

create table params_12_1_0_1
as
select par.ksppinm  name,
       val.ksppstvl value,
       val.ksppstdf def_val
from   x$ksppi  par,
       x$ksppcv val
where  par.indx=val.indx;

col name format a50
col value format a20
set lines 100
select 
  p1.name, p1.value, p2.value
from
  params_12_1_0_1 p1,
  params_12_1_0_2 p2
where p1.name=p2.name
  and p1.value<>p2.value;