Reports2017-11-18T12:27:27+00:00

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

By continuing to use the site, you agree to the use of cookies. Accept