Tutorials

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

One outstanding enhancement in Oracle 11g is its heavy investment towards self-tuning capabilities. The design implemented this through creation of automated storage, automated memory management and creation of intelligent tuning advisors. The loop ended through the provision of intelligent automation tools, resulting in a self-healing database. The most important enhancement in this is the SQL tuning advisor that is capable of tuning SQL statements automatically.

oracle Database 11g

A list of enhancements in Oracle 11g is as outlined below:

  • Automatic memory tuning
  • Fully automated SQL Tuning through the SQL Performance Analyzer
  • Automated load balancing in storage
  • Automated Diagnostic Repository
  • Enhancement of the Information Lifecycle Management (ILM) – 11g codified the approach to ILM
  • CBO statistics refresh threshold with table-level control
  • Tables interval partitioning
  • File group repository
  • Load balancing utilities

among many others.

Oracle 12c

oracle Database 12c

Here are the features that make Oracle 12c, first released in June 2013 the best Oracle experience yet:

  • Better upgrade experience – the process of upgrading is simpler and less prone to risks as much of the process uses Oracles automated Upgrade Assistants. A lot of resources on implementation and upgrades can also be available online.
  • Price differences – Oracle 12c still enjoys the uplift waive for Extended support, meaning that customers paying for the 11g support would also enjoy support for the new 12c improvements and features. An upgrade would therefore make better economic sense.
  • Awesome support – Oracle 12c has been on the market for over a year, and as with previous generations, comes with better user support than any of the previous versions.

Here is a list of the three most compelling improvements to Oracle version 12c:

  • Multi-tenant and pluggable databases offering less taxing amalgamation of several databases as well as cloud deployment into DBaaS, IaaS and PaaS.
  • Automatic data optimization – monitoring of the read-write characteristics of the database allowing grouping and data tiers according to access frequency.

Column Store and In-memory Caching and Compression – a new set of features that permit data caching in larger amounts than the conventional buffer caches. Data cached is then stored in compressed columnar format, having a dramatic impact on performance and optimization of server resources.

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