DBA Parameters – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports
Overview
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 this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Parameter Name, Non Default only, Different across Instances only
Oracle EBS Tables Used
Report Categories
Related Reports
DBA SGA+PGA Memory Configuration, DBA SGA SQL Execution Plan History, DBA AWR SQL Performance Summary, DBA SGA Buffer Cache Object Usage, Blitz Report History, DBA SGA SQL Performance Summary, DBA Sessions, DBA AWR System Metrics Summary, FND Concurrent Requests
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA Parameters 22-Dec-2025 084307.xlsx |
| Blitz Report™ XML Import | DBA_Parameters.xml |
| SQL Source | DBA Parameters.sql |
| Full Report on Enginatics | www.enginatics.com/reports/dba-parameters/ |
Executive Summary
The DBA Parameters report audits the database initialization parameters (init.ora / spfile). These parameters control every aspect of the database’s behavior, from memory allocation (sga_target) to optimizer behavior (optimizer_features_enable). Incorrect parameters are a leading cause of performance issues and instability.
Business Challenge
- Standardization: “Does our Production database have the same parameters as our Test database?”
- Performance Tuning: “Is
cursor_sharingset toEXACTorFORCE?” - Change Tracking: “Who changed
open_cursorsfrom 1000 to 500?”
Solution
This report lists the current value of all database parameters.
Key Features:
- Is Default: Indicates if the parameter is set to its default value or has been overridden.
- Is Modified: Shows if the parameter was changed in the current session.
- RAC Consistency: In a RAC environment, checks if parameters are consistent across all instances.
Architecture
The report queries GV$PARAMETER.
Key Tables:
GV$PARAMETER: The in-memory view of active parameters.
Impact
- Stability: Prevents “drift” where configuration changes are made in one environment but not others.
- Best Practices: Allows DBAs to validate settings against Oracle Support recommendations (e.g., “bde_chk_cbo.sql”).
- Troubleshooting: Quickly rules out misconfiguration as the cause of a new issue.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH