the little r12.1.3 tuning and troubleshooting guide (Soft Cover)
Are you upgrading to R12.1.3?
As more customers tackle the Release 12.1.3 upgrade, finding additional ways to minimize upgrade time has become a key goal. Reducing the time to upgrade has several benefits:
1. The faster the upgrade hardware, the more iterations can be run in a shorter period of time, resulting in a lower cost and shorter project duration.
2. Less time to do the actual upgrade means more time to test it during the production rollout.
3. A faster upgrade reduces the exhaustion factor for key players, making them less likely to make mistakes and better able to think through workarounds if there are issues.
4. If there is a problem that requires rolling back, the sooner you find it, the more time you have to do a careful recovery.
This book hones in on key ways to tune your upgrade and has the benefit of improving overall performance of your E-Business Suite environment after the upgrade as well. Learn about the benefits of Solid State Drives, Automatic Storage Management, and a hardware architecture suited to the E-Business Suite workload. Most importantly, you'll learn about tuning I/O and CPU utilization for R12 systems.
Based on TruTek's experience gained by repeatedly upgrading test environments for our clients, upgrade training classes, and client production upgrades, we've included solutions for problems that we've seen along the way.
A Little Help From My Friends
Mmmm, I get high with a little help from my friends
Mmmm, I'm gonna try with a little help from my friends
- From "With A Little Help From My Friends", Lennon and McCartney
One of the great highs about the software business…I make a ton of friends. And those friends are really, really smart. Most far smarter than me. And those far smarter friends are very generous in sharing what they know.
Case in point; a swell little package showed up in the mail last week. Pal Mike Swing at TruTek sent me a complimentary copy of his latest book: "The Little R12.1.3 Tuning and Troubleshooting Guide". Written for Oracle E-Business users, Mike's book hones in on performance tips and common issues/solutions for an EBS 12.1.3 upgrade.
Love the way this book is laid out…light on fluff, heavy on usable content. Mike works through all the administrative and introductory stuff (Table of Contents, Preface, Copyright, etc.) in the first 14 pages. Then he dives straight into the meat: 31 snippets of content on 31 basic performance tips related to your 12.1.3 upgrade. My personal favorite is Tip #16 on understanding CPU and I/O Utilization. I grapple with CPU and I/O performance issues - a lot! Years of blood, sweat and tears. Mike pretty well lays it out in nine pages. Really? How can anybody explain this stuff in nine pages??? Mike not only does it, but I personally learned a boatload by reading it.
Once Mike wraps up with the performance tips, he adds on an added bonus: troubleshooting tips for the 24 most common technical issues encountered in a 12.1.3 upgrade. How to recognize those issues, how to troubleshoot to determine root cause, and what to do about the root cause after you've identified it.
I'll be bugging Mike for a PDF version of this book, as I want it in my iPad reference materials.
Love it when I get a little help from my friends. You can find out more about Mike's book here.
Performance Tips and Troubleshooting Techniques
Performance Tuning Tips
- Performance Tip #1: Review MOS Notes for EBS
- Performance Tip #2: Review and Implement the Oracle Release Notes Recommendations
- Performance Tip #3: Review the Operating System Documentation
- Performance Tip #4: Optimize Your Architecture
- Performance Tip #5: Optimize Hardware Resources and Configuration
- Performance Tip #6: Be Aware of Your Network Configuration
- Performance Tip #7: Avoid In-place Upgrades
- Performance Tip #8: Incorporate Plenty of Disk Space to Stage Files
- Performance Tip #9: Implement and Measure Change
- Performance Tip #10: Use Oracle Wait Events to Gather Data and Diagnose the Situation
- Performance Tip #11: Get a SAN and Use Snapshots
- Performance Tip #12: Add More Memory
- Performance Tip #13: Tune Memory Usage
- Performance Tip #14: Use Solid State Drives (SSDs)
- Performance Tip #15: Use Automatic Storage Management (ASM)
- Performance Tip #16: Understanding CPU and I/O Utilization
- Performance Tip #17: Re-Organize Rows When Necessary
- Performance Tip #18: I/O Configuration– Tune the Cost of I/O
- Performance Tip #19: Understand Parallelization
- Performance Tip #20: Get More CPUs and Use Parallel Execution (Make Sure Your I/O is Fast Enough)
- Performance Tip #21: Increase PARALLEL_MAX_SERVERS
- Performance Tip #22: Avoid Using a Threaded CPU Architecture for the Database Server
- Performance Tip #24: Determine the Number of Workers to Use for the Upgrade
- Performance Tip #25: Tuning phase A35 of patch 6678700
- Performance Tip #26: Use Automatic Workload Repository (AWR) to Tune phase A35
- Performance Tip #27: Use Trace to Diagnose Performance Issues
- Performance Tip #28: Look for Functional Scripts and Datafixes from Oracle
- Performance Tip #29: Set db_file_multiblock_read_count = 8 in the Initialization File
- Performance Tip #30: Increase the Entropy of /dev/random - Performance Tuning XDOLOADER
- Performance Tip #31: Disable ARCHIVELOG Mode and Auditing
- Issue #1: Troubleshooting a Failed Worker
- Issue #2: Stopping and Starting adpatch Causes ‘Unable to find job when reading existing jobs’
- Issue #3: adpatch Restart File ‘END OF COMPLETED JOBS’ Line is Missing
- Issue #4: Verify There are No Space Issues
- Issue #5: Concurrent Processing Troubleshooting
- Issue #6: biv_b_age_h_sum_mv.xdf Fails
- Issue #7: How to Determine If a Job is Still Running
- Issue #8: Null Country Codes
- Issue #9: cstdacr.sqlFails
- Issue #10: FAILED: file bomprg.ldt - Korean Lexers
- Issue #11: APPS.HR_API_USER_HOOKS_UTILITY
- Issue #12: czhist.sql Fails
- Issue #13: iProcurement Data is Missing
- Issue #14: pechktsk.sql Fails
- Issue #15: Performance Fix to Apply VCP 220.127.116.11
- Issue #16: R12: Diagnostic Tests Are Not Available
- Issue #17: Issue With Copied Orders
- Issue #18: Long Running Job zxexemptjur.sql
- Issue #19: Apilnupg Running Very Slowly With About 6000 Jobs Remaining
- Issue #20: GMIG3MIB.sql Hangs
- Issue #21: Parallel_Max_Servers Set Too High
- Issue #22: Performance Tuning the JVM
- Issue #23: How to Find the Patches in a Merged Patch
- Issue #24: Three XLA Invalid Objects if you Don’t Apply the SLA Patch 5233248 to 11i Before the R12.1.3 Upgrade
- Item #: #0057