DBA Parameters

➜ Back to Library
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
Download
Related Blitz Reports
Blitz Report Execution History DBA SGA+PGA Memory Configuration FND Concurrent Requests 11i DBA SGA SQL Performance Summary DBA SGA Buffer Cache Object Usage DBA SGA SQL Execution Plan History FND Concurrent Requests DBA AWR SQL Performance Summary ECC G-Invoicing, Projects: G-Invoicing
Blitz Report™

Blitz Report™ provides multiple benefits: