Skip to content

DBA Parameters

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

DBA Parameters

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DBA Parameters.sql
DBA Parameters.sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title DBA Parameters | Oracle EBS SQL Report
description To validate recommended settings validate following notes: Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1) EBS…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Parameters, gv$parameter
permalink /DBA%20Parameters/

DBA Parameters – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

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)

Report Parameters

Parameter Name, Non Default only, Different across Instances only

Oracle EBS Tables Used

gv$parameter

Report Categories

Enginatics

Related Reports

DBA SGA+PGA Memory Configuration, Blitz Report History, FND Concurrent Requests 11i, DBA AWR System Metrics Summary, DBA SGA Buffer Cache Object Usage, DBA AWR SQL Performance Summary, DBA SGA SQL Performance Summary, DBA SGA SQL Execution Plan History, FND Concurrent Requests

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA Parameters 22-Dec-2025 084307.xlsx
Blitz Report™ XML Import DBA_Parameters.xml
Full SQL 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_sharing set to EXACT or FORCE?"
  • Change Tracking: "Who changed open_cursors from 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

© 2026 Enginatics