Tutorials

Compare Oracle 8i vs. 9i vs. 10g vs. 11g vs. 12c

As regards availability, the Oracle 9i DB provides an extension of Internet Database Availability in principal areas, including online data evolution, enhanced disaster recovery environments and precision database repair. Enhanced data recovery environments have seen implementation through the introduction of many features and enhancements, which can condense into the four categories below:

oracle Database 9i

  • System fault recovery – within seconds failover on Real Application Clusters, Oracle Application Clusters Guard among others.
  • Disaster recovery – LogMiner, Data Guard with automation and monitoring, zero data loss log transport, delayed mode etc.
  • Planned downtime – online changes in schema, reorganization of indexes and tables, comprehensive online index operation, dynamic parameters on databases etc.
  • Human error safeguards – Flashback Query, comprehensive log analysis and presumable space allocation etc.

It also implements new online architecture featuring the following:

  • Changes on any physical table attributes
  • Changes on many of the logical attributes as well
  • Secondary indexes on IOTs may be created and/or rebuilt online
  • Online creation and analysis of indexes
  • Online repair for physical guesses proven invalid

Oracle 10g

There are several hundred feature differences between the 9i and 10g versions, but the following offers and worth summary of the new features implemented on the Oracle 10g database version:

oracle Database 10g

  • SQL optimizer internals have been majorly altered
  • Oracle grid computing
  • RAC in Oracle 10g enhanced to enable dynamic scalability on server blades
  • Oracle Enterprise Manager (OEM) in 10g completely redesigned
  • The OEM performance pack now includes ASH and AWR tables, same as the Diagnostic Pack
  • The imp utility on the Data Pump has been replaced with impdp
  • SQLTuning Advisor
  • Automatic Database Diagnostic Monitor (ADDM)
  • SQLAccess Advisor
  • The Stripe and Mirror Everywhere Standard (SAME) introduced Automatic Storage Management (ASM)
  • Automatic Workload Repository introduced to replace the STATSPACK
  • Automated Session History (ASH)able to materialize the Oracle Wait Interface in time
  • Scheduling package dbms_job is replaced by the dbms_scheduler package
  • Introduction of the OEM Partition Manager
  • Provision for support of Multiple Temporary Tablespaces to decrease sorting stress in TEMP
  • Introduction of backup compression by RMAN

Oracle 11g

At the time of launch, Oracle 11g was a promise to consumers as an implementation of 482 new features. These changes aimed at satisfying a then hungry commercial database market that had since developed rather mature and high expectations of an RDBMS solution.

About the author

Admin

Naaz is a web designer and loves to find new tips and tricks for creativity purposes and likes to share them with the people.

6 Comments

  • Thank you Jenny for such an interesting post on various versions oracle. I have been reading blogs on various niche like database, oracle. I have also got help from remote dba experts regarding oracle and many other tools which are used for database designing.

  • Good post! Thank you very much for informative article. I have been doing discussion with my team members who are remote dba experts. I will keep this topic in front of them as it gives detail description of oracle. Keep sharing such articles in future. Thumps up for the article.

  • So much needed comparison between Oracle versions. Every version has some added features. Most database administrator doesn’t know the difference between the versions of the oracle database. This is most useful article for such database administrator. The description about each version can be taken through remote dba services. Thank you Jenny for sharing this article with us. Hope to see more articles in future. Well done.

  • Thanks you for Jenny Richards for sharing such a article. Article has many useful points which I like to share with my friends and discuss it with them. Good to read!! I like to read and gather more information as you post has some interesting information. If you are interested to know more about database, then you can go for remote dba services. Looking more article on same

Leave a Comment