Erintech IT Solutions for Oracle Licensing / licensing, DBA, database migration consultancy. Buy oracle with confidence from a UK Oracle partner. We are expert consultants in these areas: RAC, Oracle Real Application Clusters, Oracle Clusterware, Oracle database migration and Oracle APEX (Application Express). We are experienced with Oracle 7, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g Phone us now to discuss your Oracle Licence / License requirements. We guarantee best discount Oracle price - we will provide a better pricing against any genuine UK Oracle quotation. This applies to Oracle Licence, support and training. Discount Dell Server, discount IBM Server Oracle discount licences, Dell discount servers and IBM discount hardware. Erintech is an Oracle Partner, Dell Partner and IBM partner.

Bookmark and Share

 

 

 

 

 

“The Database Replay and SQL Plan management features alone are worth upgrading to Oracle Database 11g”

 

 

 

 

 

 

 

 

“The new management capabilities of Oracle Database 11g makes it easier for database administrators to monitor and tune systems”

 

 

 

 

 

 

 

 

 

“Oracle Advanced Compression can significantly reduce the cost to purchase, power, house, and manage your storage infrastructure”

 

 

 

 

 

 

 

 

 

“Oracle Advanced Security and Oracle Database Vault provide a comprehensive, robust solution to your security and compliance needs”

 

 

 

 

 

 

 

 

 

“Oracle Streams performance is up to 2 times faster, just one of the performance improvements in Oracle Database 11g”

The Business Case for Oracle 11g

 

Overview

Oracle 11g was released in mid 2007 but even now many installations are still using earier versions, including 9i and 8i.

This conservative attitude is easily understood: "if it ain't broke, don't fix it". If the existing installation is serving the users as intended, why invest in the time and cost of an upgrade?

This document presents the business case for an upgrade to 11g based on sound ROI and functional benefits.

 

ROI benefit - improved database performance

11g offers improved performance in a variety of areas; it also offers data compression. Together, these factors could extend the life of both your servers and your storage. In addition, Active Data Guard can make use of an otherwise dormant backup system.

  • Oracle Database 11g introduces many performance breakthroughs. New server and client-side result caching has improved the performance of often-repeated statements by 25% or more. New native compilers for PL/SQL and Java have drastically improved performance, up to 2 times faster for PL/SQL and 11 times faster for Java.
  • Reduced Storage Needs - Oracle Advanced Compression offers a comprehensive set of compression capabilities for all data types,significantly reduces database storage for structured, unstructured, and backup data. While storage costs are an obvious tangible benefit of compression, memory efficiency is enhanced as data in memory is in a compressed format. This allows more data to be stored in memory and reduces the number of I/Os, which may improve performance.
  • Oracle Active Data Guard enables customers to use their standby database to improve performance in their production environments. By offloading workloads from production to a standby system, Oracle Data Guard helps enhance the performance of production systems and provides a more cost-effective disaster recovery solution

Improved DBA productivity

  • Oracle Diagnostics Pack 11g: Diagnosing a slowly performing system is a time consuming task. Oracle Diagnostics Pack 11g is a self-diagnostic solution that enables Oracle Database 11g to automatically monitor and diagnose its performance problems, thereby liberating administrators from this difficult and arduous task.

  • Oracle Tuning Pack 11g: A poorly tuned business application can potentially affect not just a few users but an entire business operation. For this reason companies invest significant resources to ensure smooth running of applications vital for their businesses. Oracle Tuning Pack 11g offers a cost effective solution that automates application and SQL tuning and eliminates the need for manual tuning. System performance and reliability are enhanced and management costs are significantly lowered.

Functional Benefits

  • Oracle Real Application Testing: System changes such as hardware/software upgrades and patch applications are essential for businesses to maintain a competitive edge. Such changes can lead to unexpected and undesirable behavior. Often, despite extensive testing, many problems are only detected on production deployment, resulting in unplanned downtime and loss of revenue.Oracle Real Application Testing combines a workload capture and replay feature with a SQL performance analyzer to help test changes against real-life workloads. Testing time is reduced and testing accuracy is improved, resulting in lower production deployment risk and decreased business costs.
  • Data security and compliance (1): Oracle Advanced Security provides an easy-to-deploy and comprehensive solution for protecting all communication to and from an Oracle Database, providing both native network encryption and SSL based encryption.
  • Data security and compliance (2): Oracle Database Vault controls the who, when, and where of data and applications that can be accessed – protecting a business against the most common security threat: malicious internal users. It achieves this by controlling access to application and database data, even by highly privileged users.

Support

The cost of maintaining an older version must also be accounted for.

  • Oracle announced the desupport of Oracle Database Release 9.2 as of July 2007. Extended Support ends in July 2010
  • For customers who are on Database Release 10.1, Premier Support ended January 2009
  • For customers on Database Release 10.2, Premier Support ends July 2010.

 

Summary

We believe there is a strong case to upgrade to 11g, based on ROI, including simplified DBA load and reduced support costs.

The upgrade process is simplified for 11g:

Over the last several database releases, many improvements have been made to the upgrade process, making it easier to successfully upgrade to new releases of Oracle software.
One of the most significant enhancements is the Database Upgrade Assistant (DBUA). The DBUA automates the various steps in an upgrade to a new release or patchset. It provides a graphical user interface to perform an upgrade, monitor its progress, and review the status of the upgraded database. It can upgrade a Single Instance database, a Real Application Clusters database, or an Automatic Storage Management instance (ASM).

Conclusion

This document presents a case for upgrading to Oracle 11g, but all installations are different and you should perform your own assessments before making a final decision. Note that some of the benefits assume appropriate licensing and we will be pleased to discuss this.

For more detail see the Oracle White Paper "Why Upgrade to Oracle Database 11g?"

For further information and advice, contact us