DBA Parameters

Description
Categories: Enginatics, Toolkit - DBA
Repository: Github Columns: Inst Id, Num, Name, Type, Value, Display Value, Default Value, Isdefault, Isses Modifiable, Issys Modifiable ...
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)
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
Non Default only
x.isdefault='FALSE'
LOV
Different across Instances only
x.dupl_count>1
LOV
Parameter Name
x.name=:parameter_name
LOV