Oracle Database History & Oracle Release Versions

Hi,

I will explain about History of Oracle Database and Oracle versions in this article.

 

Those who do not know what is the Database and Relational Database management systems ( RDBMS ) can read the following article.

 

Oracle was founded on June 16, 1977 by Larry Ellison, Bob Miner and Ed Oates under the name Software Development Laboratories (SDL). Until 1979, the company did not succeed with this name, and in 1979, three adventurous friends who changed the company name to Relational Software Inc worked in Relational Software Inc. until 1982. The brilliant trio, which has consistently focused on Database management systems and made its first database trial with IBM, failed.

In one of the following experiments, the Oracle Database System developed under the leadership of Bob Miner. In 1982, the name of the company was identified with the name of its products and changed to Oracle Systems Corporation. It was changed to Oracle Corporation in 1995 and this name has continued to this day.

TOP Features according to Version of Oracle database from the first version are as follows.

Version &   Year                            New Features
Oracle v2,         1979First commercially SQL-based RDBMS
Oracle v3,         1983Concurrency control, data distribution, scalability
Oracle v4,         1984Multiversion read consistency
Oracle v5,         1985 Client/server computing Support & distributed database systems
Oracle v6,         1988Row-level locking, scalability, online backup and recovery, PL/SQL, Oracle Parallel Server
Oracle  7,         1992PL/SQL stored procedures, Triggers, Shared Cursors, Cost Based Optimizer, Transparent Application Failover
Oracle  8,         1997Recovery Manager, Partitioning, Dataguard, Native internet protocols, Java, Virtual Private Database
Oracle  9,         2001Oracle Real Application Clusters (RAC), Oracle XML DB, Data Mining, Streams, Logical Standby
Oracle 10gR1,  2003Grid infrastructure, Oracle ASM, Flashback Database, Automatic Database Diagnostic Monitor
Oracle 10gR2,  2005Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Transparent Data Encryption
Oracle 11gR1,  2007Active Data Guard, Secure Files, Exadata
Oracle 11gR2,  2009Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance
Oracle 12cR1,  2013Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service
Oracle 12cR2,  2016Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer
Oracle 18c,      2018Autonomous Database, Data Guard Multi-Instance Redo Apply, Polymorphic Table Functions, Active Directory Integration
Oracle 19c,      2019Automatic Indexing, Data-guard DML Redirect,Partitioned Hybrid Tables, Real-time Stats + Stats Only Queries

 

 

Oracle 8

RMAN (Recovery Manager), which is the backup and recover tool of Oracle database, and Partitioning feature, which makes a great contribution to the Database management system in terms of performance, were introduced with this version.

Disaster Recovery feature called Dataguard is released with Oracle 8.

 

Oracle 9

The most important feature in this version is undoubtedly the Real Application Cluster (RAC) feature. With this feature, Oracle Instance, which is installed on multiple servers at the same time, provides high availability of databases, which we call high availability.

There is still no feature like RAC (active-active) in other RDBMS. The RAC feature has become a sine qua non for corporations, especially for customers with instant money flows such as banking and insurance, which we call business critical systems.

 

 

 

Oracle 10g

With Oracle 10g, we now have the ability to manage Oracle’s storage management from operating systems, which we now call Automatic Storage management. The Real application Cluster feature, which comes with Oracle 9, has been improved and the Grid Infrastructure feature has also come with 10g.

Flashback feature, which is one of the most important features for database administrators and shortens the recover on user errors, was also introduced with Oracle 10g.

 

Advanced Compression and Transparent Data Encryption are also introduced with Oracle 10g.

 

 

Oracle 11g

With this version, Exadata, which was designed as a database machine introduced by Oracle on the hardware side, was introduced. Oracle 11g was the first database version used in Exadata.

Active dataguard feature was introduced in this version for the disaster recovery feature of Dataguard databases.

Data Redaction, Hybrid Columnar Compression and Cluster File System are another feature of Oracle 11g.

 

Oracle 12c

Oracle  has announced many different features with 12c version, it has already echoed in the market and the most important reason for this is that it announces Cloud feature. Now the concept of g (grid) in 10g and 11g has been replaced by c (cloud).

Oracle 12c’s TOP features are as follows.

  • Oracle Multitenant
  • Far Sync
  • Online Datafile move
  • Table Restore from Full Backup
  • İnvisible Column
  • Automatic  Data Optimization
  • Flex ASM
  • Data Masking
  • Multiple index for same column.

 

 

Oracle18c

Autonomous Database and Data Guard Multi-Instance Redo Apply are the most important features in this version. Let’s look at what this feature is.

Autonomous Database

Oracle Autonomous Database is a cloud-based technology introduced in 2017, designed to automate many of the routine DBA tasks required to manage Oracle databases. In particular, Oracle says that database administrators (DBAs) will have the opportunity to do higher and more strategic tasks rather than routine and tedious tasks . Because lots of DBA tasks will be done by Oracle, thus Oracle will be a self-managed database.

Autonomous Database feature is provided as a cloud service created by machine learning algorithms called self-driving, self-safety and self-repair slogans.

 

 

 

Oracle 19c

  • Automatic Indexing
  • Data-guard DML Redirect
  • Partitioned Hybrid Tables
  • Real-time Stats + Stats Only Queries features.

 

I will continue to add new features and new versions in the future as soon as new version of Oracle has released.

 

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *