Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 3 April 2012

List of Oracle Database Edition and Major Release

Oracle Corporation subdivides its product into varying "editions" - apparently for marketing and license-tracking reasons. In approximate order of decreasing scale, the editions are listed below.
Enterprise Edition (EE): Includes more features than the 'Standard Edition', especially in the areas of performance and security. Oracle Corporation licenses this product on the basis of users or of processors, typically for servers running 4 or more CPUs. EE has no memory limits, and can utilize clustering using Oracle RAC software.
Standard Edition (SE): Contains base database functionality. Oracle Corporation licenses this product on the basis of users or of processors, typically for servers running from one to four CPUs. If the number of CPUs exceeds 4 CPUs, the user must convert to an Enterprise license. SE has no memory limits, and can utilize clustering with Oracle RAC at no additional charge.
Standard Edition One: Introduced with Oracle 10g, has some additional feature-restrictions. Oracle Corporation markets it for use on systems with one or two CPUs. It has no memory limitations.
Express Edition:  Introduced in 2005, offers Oracle 10g free to distribute on Windows and Linux platforms (with a footprint of only 150 MB and restricted to the use of a single CPU, a maximum of 4 GB of user data and 1 GB of memory). Support for this version comes exclusively through on-line forums and not through Oracle support.
Oracle Personal Edition: Provides the functionality of the "high end" Enterprise Edition but marketed to (and licensed for) single-user developers working on personal workstations.
Oracle Database Lite: Intended to run on mobile devices. The database, partially located on the mobile device, can synchronize with a server-based installation.

Timeline of Oracle RDBMS Major Release Version

Release Version
Oracle version 1
Oracle version 2
Oracle version 3
Oracle version 4
Oracle version 5
Oracle version 6
Oracle version 7
Oracle version 8
Oracle version 8i
Oracle version 9i
Oracle version 10g
Oracle version 11g

List of Oracle database Version Release

From Oracle1 to Oracle6 there was no Release numbering. Since Version 7, Oracle's RDBMS release numbering has used the following codes:
Oracle7: 7.0.16 — 7.3.4
Oracle8 Database: 8.0.3 — 8.0.6
Oracle8i Database Release 1: —
Oracle8i Database Release 2: —
Oracle8i Database Release 3: —
Oracle9i Database Release 1: —
Oracle9i Database Release 2: —
Oracle Database 10g Release 1: —
Oracle Database 10g Release 2: —
Oracle Database 11g Release 1:

Meaning of 'I' and 'G' in oracle:
Since starting 1999 oracle added I with the version 6i, 8i and 9i where i signifies 'internet' support with the particular version with its built in java virtual machine (JVM).
Since starting 2003 with version 10g, 11g, 12g where G signifies 'Grid Computing' with the particular release. The Grid Computing enables the clusters of low cost, industry standard server to be treated as a single unit.


  1. eToro is the #1 forex trading platform for newbie and pro traders.