Home / NEWS AND UPDATES / Check Your EBS Database Configuration with Database Parameter Settings Analyzer

Check Your EBS Database Configuration with Database Parameter Settings Analyzer

Check Your EBS Database Configuration with Database Parameter Settings Analyzer

By: Steven Chan | Senior Director

Database ParaIn addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

Here’s an index to these tools:

Spotlight on Database Parameter Settings Analyzer

We publish a definitive list of Oracle Database initialization parameter settings for the optimal performance of Oracle E-Business Suite 12.2, 12.1, and 12.0:

This document is updated regularly; for example, it was recently updated to account for changes introduced by the April 2017 updates to the AD and TXK utilities.

It can be challenging to keep up with those changes simply by scanning Note 396009.1 yourself.  You can automate this process by using the Database Parameter Settings Analyzer:

The Database Parameter Settings Analyzer compares your database’s parameter settings to the latest recommendations in Note 396009.1.  It reports on any differences, and makes recommendations about your sga_target, shared_pool_size, shared_pool_reserved_size and processes parameters based upon the number of active users for your environment.

This tool can be run manually or configured to run as a concurrent request, so it can be scheduled to be run periodically and included in regular database maintenance cycles.

Can this script be run against Production?

Yes. There is no DML in the Analyzer Script, so it is safe to run against Production instances to get an analysis of the environment for a specific instance. As always it is recommended to test all suggestions against a TEST instance before applying to Production.

Source: https://blogs.oracle.com/stevenchan/check-your-ebs-database-configuration-with-database-parameter-settings-analyzer

About Syed

As a certified and experienced Oracle Database Administrator with Almost 10 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

Oracle Database Release Update 19.9 (October 2020) Now Certified With EBS 12.1.3

We are pleased to announce that Oracle Database Release Update 19.9 ( is now certified …

Leave a Reply