DBA Parameters

➜ Back to Library
Description
Categories: Enginatics
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)

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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: