Home › Discussions › Questions & Answers › Checking Database Initialization Parameter Compliance for EBS

Checking Database Initialization Parameter Compliance for EBS

Avatar photoCustomer Questions & Answers 5 replies

We are preparing for an upgrade and need to ensure all our database initialization parameters comply with Oracle’s requirements for EBS Release 12. Which Blitz Report should I run for this validation?

5 replies

  • Support Enginatics

    Please run the DBA Parameters report. This report helps validate recommended settings against critical Oracle notes, such as Document 396009.1, ‘Database Initialization Parameters for Oracle E-Business Suite Release 12’.

  • If I discover that Automatic Optimizer Statistics Collection is active, what steps should I take according to best practices?

  • Support Enginatics

    If Automatic Optimizer Statistics Collection is active, it must be deactivated for EBS by setting the DB parameter `_optimizer_autostats_job=false`. You should instead schedule the concurrent program ‘Gather Schema Statistics’.

  • Where can I find typical recommended starting values for critical parameters like `processes`, `sga_target`, and `pga_aggregate_target` based on user count?

  • Support Enginatics

    The tuning documentation provides tables listing typical parameter settings based on user concurrency levels, ranging from development instances (11-100 users) up to 1001-2000 users, detailing values for parameters like `processes`, `sessions`, `sga_target`, and `pga_aggregate_target`.

  • You must be logged in to reply to this post.