FAQs
Q 21 How will you reduce down time in 11i to R12 upgrade? APPLICATION LEVEL – Take advantage of patch merge & hot patching of help/nls portions – Use Shared APPL_TOP, shared application tier with Distributed AD (use of multiple application nodes to run ADPATCH in parallel) – Prepare a complete list of pre and post patches and recommended code levels including CUP – Critical Upgrade Patches – Apply latest RUPs for ATG/AD/OAM prior to upgrade – Purge Data aggressively – Re-gather Statistics close to start of actual upgrade downtime – Batch size – 10K is suitable for most installs, you can test other values from 1K up to 100K – Number of Workers – Starting rule-of-thumb is between 1 and 1.5 x #CPUs – Order NLS Sync patchsets in Oracle instead of download and apply it for each patch. – use staged application system ( not good for r12.2) DATABASE LEVEL – Maximize SGA and PGA sizing – Adjust with help from AWR pool advisories – Set job_queue_processes = # of CPUS...