DBA Parameters

Description
Categories: Enginatics, Kcapps
Repository: Github
To validate recommended settings validate following notes:
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
EBS Database Performance and Statistics Analyzer (Doc ID 2126712.1)
Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1)
Run DBA Parameters and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name
x.name=:parameter_name
LOV
Non Default only
x.isdefault='FALSE'
LOV
Different across Instances only
x.dupl_count>1
LOV