We have updated our recommendations for minimizing downtimes when upgrading to EBS 12.2.8:

Written by Jim Machin, a senior member of our Applications Performance group, this white paper contains a wealth of detailed technical recommendations for reducing the amount of time needed for an
EBS 12.2.8 upgrade. 

Events vs. sessions bottlenecks diagram

It covers:

  • Technical preparation and planning activities
  • Diagnostics for monitoring and troubleshooting performance issues
  • Common solutions to performance issues
  • Oracle Applications Tablespace Model (OATM) considerations
  • Methods for purging old data
  • Gathering statistics
  • Detailed recommendations for improving resource management, sizing, and workloads

Latest updates to this whitepaper

This white paper is updated regularly with new tips and recommendations based upon our Application Performance group’s work with actual EBS 12.2 customers and their Service Requests.  All EBS 12.2 sysadmins should monitor this white paper regularly.  This latest version includes the following updates:

  • High Level of “enq: KO – fast object checkpoint” wait event – Internal Only
  • Middle Tier Sizing / Applications Tier Bottlenecks
  • Additional Fixed Object and Dictionary statistics information and advice.
  • Additional Materialized View advice, including ADZDMVREFRESHNEEDED.sql
  • Explicit mention of Online Patching Readiness reports and compliance checker in pre upgrade activities.
  • Improved explanation of how AD_ZD_TABLE_APPLY.sql uses DBMS_PARALLEL_EXECUTE to split work into chunks and call DBMS scheduler.
  • Addition of solutions for long running AD_ZD_TABLE_APPLY.sql.
  • Specific instances where extent size and high row length could impact batch size and performance adversely.
  • Advice for initialization parameter db_writer_processes
  • Additional references to documents 554539.1 1065393.1 and 2125596.1. Remove references to document 1585857.1
  • Amend SGA and Huge Pages advice

Related Articles