Upgrading to 11g–Why,How and Best Practices

作者: Maclean Liu , post on December 20th, 2010 , English Version
【本站文章除注明转载外,均为本站原创编译】
转载请注明:文章转载自: Oracle Clinic – Maclean Liu的个人技术博客 [http://www.oracledatabase12g.com/]
本文标题: Upgrading to 11g–Why,How and Best Practices
本文永久地址: http://www.oracledatabase12g.com/archives/upgrading-to-11g-why-how-and-best-practices.html

So what specifically is included in the Lifetime Support packages?

Premier Support provides complete maintenance and support for five years from the application’s general availability date. Premier Support includes:
Major product and technology releases
Technical support
Updates, fixes, security alerts, and critical patch updates
Tax, legal, and regulatory updates
Upgrade scripts
Certification with new third-party products/versions
Certification with new Oracle products
Extended Support provides up to three additional years of support for specified releases for an additional fee, and includes all the features of Premier Support except for certification with any new third party products or versions.
Sustaining Support provides technical assistance for as long as you license and maintain support on your Oracle PeopleSoft products, but because development is no longer being done on these versions, no new updates or fixes will be provided. Sustaining Support provides you with continued access to Customer Connection and the Global Support Center (GSC). The GSC will be able to assist you with known issues, but again will be unable to work on new bugs/issues reported. Sustaining Support also does not provide any new security alerts, critical patch updates, new tax, legal, and regulatory updates, or any new upgrade scripts

My Oracle Support Configuration Manager is a capability that automates the information exchange between Oracle and our customers enabling faster resolution and proactive detection of customer issues.

My Oracle Support Configuration Manager utilizes core configuration management capabilities available from Oracle Enterprise Manager (we’ll talk more about this relationship a little later).
My Oracle Support Configuration Manager gives you the ability to create Service Requests with improved tracking and reporting.
With the new Knowledge Management Tab you can do Enhanced Knowledge searches using PowerViews
And provides tools for truly proactive problem avoidance
This functionality is now available for all of our customers at no extra cost, as part of your current Premier Support services.
We’re quite excited about this, as this represents the next major step in the evolution of support delivery for us, something we have been working on for quite some time as a major improvement for our customers

Oracle Advisor Webcasts Now Available Through My Oracle Support and MetaLink!
A new way to receive information about your Oracle E-Business Suite solutions
Go to MetaLink Note 398877.1 – Welcome to the Oracle Advisor Webcast Program!
Includes links to the Advisor Webcast page
Instructions for registering and viewing both live and archived webcasts
The current menu of scheduled webcasts to choose from

Challenges & Best Practices

  • Optimizer – prevent execution plan changes:
    • Classical approach:
      • Rule Based Optimizer (Please note: RBO desupport since Oracle 10g)
      • Hints
      • Stored Outlines
      • Rewriting SQL statements
      • optimizer_features_enabled=n.n.n
      • Change specific optimizer parameters
      • Import and fix object and system statistics
    • Modern, efficient and better resource consumption:
      • SQL Plan Management
      • SQL Profiling

Real Application Testing

  • Goal:
    • Enable successful adoption of new technology and features -specifically new releases of the database – at low-cost and low-risk by:
      • Record and replay a real workload to see how the new system performs
      • Finding regressions and changing plans before the upgrade
  • Licensable database pack “Real Application Testing”
    • Available with Oracle Database 11.1.0.6
    • Available with patch set 10.2.0.4
    • Available as single patch for 9.2.0.8 and 10.2.0.3
      • For patch numbers please see Note:560977.1
    • Can be used for upgrades from
      • 9.2.0.8 to 10.2.0.3/4
      • 9.2.0.8 to 11.1.0.x
      • 10.2.0.3/4 to 11.1.0.x

Real Application Testing consists of:

  • Database Replay
    • Package DBMS_WORKLOAD_CAPTURE
    • Package DBMS_WORKLOAD_REPLAY
  • SQL Performance Analyzer (SPA)
    • Package DBMS_SQLPA
  • SQL Tuning Sets (STS)
    • Package DBMS_SQLTUNE

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

  1. Upgrading to RAC 11g R2 What you should know
  2. JDBC Batch Processing With Subquery in Select Clause Returns Incorrect Results With 11G Release 1 Database.
  3. Upgrade to Oracle Database 11g: Single Instance to RAC & ASM
  4. Oracle Database 11g: Java Development Student Guide

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>