DBA Database Parameter Validation – 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

Replicates the database initialization-parameter validation performed by Oracle’s EBS Database Performance and Statistics Analyzer (My Oracle Support Doc 2126712.1 / KB627702), so DBAs no longer need to download, install and run that analyzer to check EBS parameter compliance.

Reference: https://support.oracle.com/rs?type=doc&id=2126712.1

It compares the current instance settings in v$system_parameter2 against Oracle’s required values for the running RDBMS version (11.1 / 11.2 / 12.1 / 19c) and EBS release, per My Oracle Support Doc 396009.1 / KA1002 (“Database Initialization Parameters for Oracle E-Business Suite”). https://support.oracle.com/support/?kmContentId=11158187

Three sections:

  1. Mandatory Database Parameters - current vs required value, with a Check of OK / NOT FOUND:OK / ERROR.
  2. Database Parameters to be Removed - parameters (and events) that are explicitly set but should be removed for the running RDBMS version.
  3. Database Additional Parameters - other non-default parameters set on the instance, flagging hidden (underscore) parameters that should not be set.

By default the “Only show errors” parameter is Yes, so only actionable rows are shown (Check = ERROR, parameters to be removed, and hidden parameters that should not be set). Clear the parameter to list every checked parameter. Memory sizes are shown in M / G (e.g. 600M, 2G).

Prerequisite: APPS requires SELECT on v$system_parameter2 (v_$system_parameter2). On most EBS instances this grant already exists; if not, as SYSDBA run: create or replace public synonym V$SYSTEM_PARAMETER2 for SYS.V_$SYSTEM_PARAMETER2; grant select on sys.V_$SYSTEM_PARAMETER2 to apps;

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

Only show errors

Oracle EBS Tables Used

ref0, dual, v$instance, v$system_parameter, v$system_parameter2

Report Categories

Enginatics

DBA AWR System Metrics Summary, DBA SGA+PGA Memory Configuration, DBA Sessions, CAC Inventory Pending Cost Adjustment - No Currencies, CAC ICP PII WIP Material Usage Variance, CAC Item Cost & Routing, CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End), CAC Missing Material Accounting Transactions

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 Database Parameter Validation 16-Jun-2026 163655.xlsx
Blitz Report™ XML Import DBA_Database_Parameter_Validation.xml
SQL Source DBA Database Parameter Validation.sql
Full Report on Enginatics www.enginatics.com/reports/dba-database-parameter-validation/

Case Study & Technical Analysis: DBA Database Parameter Validation

Executive Summary

DBA Database Parameter Validation checks the initialization parameters of an Oracle database instance against the values Oracle requires for an E-Business Suite installation. It reproduces the validation performed by the Oracle EBS Database Performance and Statistics Analyzer, so a DBA can confirm EBS parameter compliance from a spreadsheet without downloading and running that analyzer. The report is intended for database administrators and EBS technical consultants preparing a new instance, reviewing an upgrade, or auditing a production database against Oracle’s guidance in My Oracle Support note 396009.1.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. The reference rows are generated in a common table expression from literal selects against DUAL, each carrying a parameter name, a category, the statement scope and the required value.
  2. A second common table expression reads the database version from V$INSTANCE and the EBS release from FND_PRODUCT_GROUPS.
  3. The reference rows are filtered to the running database version and EBS release.
  4. Each section of the output is a union of outer joins from the reference rows to V$SYSTEM_PARAMETER2, so parameters that are not set still appear.
  5. The final result is ordered by section, check result and parameter name.

Parameters & Filtering

Performance & Optimization

FAQ

Q: Which database parameters does this report check? A: It checks the mandatory parameters for the running database version and EBS release, the parameters that should be removed, and any other non-default parameters on the instance.

Q: Why does the report show a row with NOT FOUND:OK? A: The parameter is not set on the instance, but its default value matches the required value, so the check passes.

Q: What does the report need to run? A: APPS needs SELECT on the V$SYSTEM_PARAMETER2 view. The report description gives the synonym and grant statements to run as SYSDBA when that access is not already in place.

© Enginatics GmbH