Updated: Minimizing EBS 12.2.8 Upgrade Downtimes

November 5, 2018 | 2 minute read
Steven Chan
Senior Director
Text Size 100%:

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


Steven Chan

Senior Director

Steven Chan was a Senior Director in the Oracle Applications Technology Group.  He managed EBS technology stack certifications, ATG product management, ATG documentation and curriculum, and ATG Quality Assurance in the E-Business Suite Development division.

Steven joined Oracle in 1998.  Steven retired from Oracle in 2019. Prior to joining Oracle, he held positions with IBM, Deloitte & Touche Consulting, and other software companies. 

Steven is an Oracle ACE and a three-time recipient of the Oracle Applications User Group 'Ambassador of the Year' Award (2007, 2009, 2010). Steven received the Oracle Applications User Group Lifetime Service Award in 2011.

Previous Post

Updated for EBS 12.2.8: Reference Tools for Developers

Steven Chan | 1 min read

Next Post

New White Paper: Oracle EBS 12.2 with Database Advanced Row Compression

Steven Chan | 1 min read