I returned from OAUG/Collaborate with a cold and multiple overlapping development crises. Fun. Now that those are (mostly) out of the way, it’s time to get back to clearing out my article backlog. Premier Support for the 10gR2 database
ends in July 2010. If you haven’t already started planning your 11g database upgrade, we recommend that you start soon. We have certified both the 11gR1 (11.1.0.7) and 11gR2 (11.2.0.1) databases with Oracle E-Business Suite; see this blog’s
Certification summary to links to articles with the details. Our Applications Performance Group has reminded me that they have a whitepaper loaded with practical tips intended to make your 11g database upgrade easier. No vacuous marketing rhetoric here — this is strictly written for DBAs. A must-read if you haven’t already upgraded to either 11gR1 or 11gR2, and highly recommended even if you have. You can download this whitepaper here:
This whitepaper covers:
- Pre-upgrade tips
- Gather dictionary statistics
- Manage CBO statistics
- Gather performance metrics
- Save execution plans
- Test (including capturing and replaying workloads)
- Post-upgrade tips
- init.ora parameters
- Gather statistics
- Disable automatic optimizer statistics collection
- Plan stability using SQL Plan Management (SPM)
- Detect and tune performance changes using SQL Performance Analyzer (SPA)
- Real-time SQL monitoring
- Incident packaging service
- New 11g Performance-related features
- Optimizer enhancements
- Partitioning enhancements
- Advanced Compression
- Fixes and workarounds for known issues
- Mandatory patches
- Options fixes and workarounds
E-Business Suite Benchmarks Also Available The Applications Performance Group is also responsible for our Oracle Applications Standard Benchmark (OASB), a standard workload that tests the performance and scalability of Oracle Applications and provides metrics for the comparison of Oracle Applications performance on different system configurations. Copies of independently-audited E-Business Suite benchmarks for both Oracle E-Business Suite Release 11i and 12 are available here:
Related Articles
