Database Upgrades


Maintaining and upgrading databases can be a difficult task. For VARs and systems integrators who manage and maintain an Oracle database for their customers, being current with common pain points can make the support role much easier. These are some of the questions that customers are asking on a regular basis:

  • Can you describe the difference in performance tuning between different database version and editions?
  • What patchsets should I apply on my database?
  • What pitfalls does the upgrade might have?
  • What tuning indicators can I use for my database?
  • What are the most common causes and indications of database performance problems? What should I look for before and after the upgrade? What tools should I use to tune SQL queries and other database code?
  • Can you outline simple guidelines to ensure that the security requirements are made a part of any database upgrade plan?

With an experienced database professional – we now can make upgrading database version safe and easy.


  • Prepare to Upgrade – Upgrade planning document
  • Develop a Testing Plan including:
    • Upgrade testing
    • Minimal testing
    • Functional testing
    • Integration testing
    • Performance testing
    • Volume and Stress load testing
  • Prepare a backup strategy document
  • Test the upgrade process
  • Test the upgraded test database
  • Upgrade database
  • Performance tuning after upgrade
  • Limited applicative and infrastructure support after upgrade (not replacing vendor support)


Having a database at the latest version is important for many reasons. Bug fixes, new features, improved optimization, vendor support and more are some of them. Using an experienced team to upgrade your database will result in shorter and safer upgrade process and a shorter adaptation time to adjust to the new version, thus saving time, resources and money.