DBA Initialization Parameters

Description
Categories: DBA, Enginatics
select
x.*
from
(
select
gp.*,
count(distinct gp.value) over (partition by gp.name) dupl_count
from
gv$parameter gp
) x
where
1=1
order by
x.name,
x.inst_id
Parameter Name SQL text Validation
Different across Instances only
x.dupl_count>1
LOV
Non Default only
x.isdefault='FALSE'
LOV