DBA Database Parameter Validation – Oracle EBS SQL Report

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

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;

Report Parameters

Only show errors

Oracle EBS Tables Used

ref, v$system_parameter2

Report Categories

Enginatics

QP Price List Upload, QP Modifier Upload, BOM Routing Upload, BOM Routings, AR Customer Upload

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

© 2026 Enginatics