- 1 Database Editions
- 2 Database Options
- 3 Database features
- 4 Database version history
- 5 Desupport dates
- 6 Also see
The Oracle database server is available in the following editions:
Oracle Enterprise Edition
Oracle's top-end database server product for big enterprise customers.
Oracle Standard Edition
Four-processor version of Oracle Database, including full clustering support (Real Application Clusters).
Oracle Standard Edition One
Two-processor version of Standard Edition at an attractive entry-level price. While Real Application Clusters is included in the installation package, the right to use is NOT included with Standard Edition One.
Oracle Personal Edition
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).
Oracle Express Edition
Free version of Oracle that is limited to 1 processor, 1 GB RAM and 11 GB of data. For more info, see Oracle XE.
The following optional database options can be purchased separately. These options are only available with the Enterprise Edition (the only exception is RAC):
- Partitions can be stored in different tablespaces;
- Partitions can be added/ removed while users are working;
- Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).
The Spatial option store geographical information (GPS coordinates for instance) with records.
Real Application Clusters Option
Advanced Security Option
Oracle Advanced Security (ASO), formerly called the Advanced Networking Option, provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols. ASO is only available with Oracle Enterprise Edition.
Oracle Label Security
Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.
Oracle OLAP is a powerful multidimensional calculation engine with a complete set of analytical functions fully integrated within the Oracle Database. Oracle Database OLAP Option adds multidimensional data storage to Oracle Database, of the type previously only available in the best of the separate standalone multidimensional databases. Often generically described as "cubes", Analytic Workspaces inside Oracle Database provide fast scalable query performance and ease of use, especially for calculation intensive BI (or operational) applications - and offer a sophisticated alternative to traditional summary management in modern BI/Data Warehousing architectures.
Unlike previous generation separate engines (like Oracle Express Server) however, Oracle Database cubes (their data and calculations) are available to virtually any client tool or application, via simple SQL. Because Oracle Database OLAP Option cubes are a feature of the Oracle Database, they inherit other features from the Oracle Database including Security, Performance and Scalability, High Availability and Manageability capabilities.
Oracle Data Mining
A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.
Total Recall is based on Oracle's Flashback feature and will allow users to query data "AS OF" an earlier time in the past. This will allow companies to "archive" data for auditing and regulatory compliance. For more info, see Oracle Total Recall.
Option used to compress data. For more info, see Oracle Advanced Compression.
Real Application Testing (RAT)
RAT can be used to capture, analyze and replay database transactions. For more info, see Real Application Testing.
A database feature, in contrast with an option, is provided free with the database software.
Most DBA's and developers work with multiple versions of Oracle at any particular time. To see what features were introduced in each version, refer to the version pages: Oracle 2, Oracle 3, Oracle 4, Oracle 5, Oracle 6, Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g.
Database version history
The major Oracle versions, with their latest patch-sets are:
- Oracle 7: ... - 220.127.116.11
- Oracle 8: 8.0.3 - 8.0.6
- Oracle 8i: 18.104.22.168 - 22.214.171.124
- Oracle 9i (Release 1): 126.96.36.199 - 188.8.131.52
- Oracle 9i (Release 2): 184.108.40.206 - 220.127.116.11
- Oracle 10g (Release 1): 10.1.0.2 - 10.1.0.5
- Oracle 10g (Release 2): 10.2.0.1 - 10.2.0.5
- Oracle 11g (Release 1): 18.104.22.168 - 22.214.171.124
- Oracle 11g (Release 2): 126.96.36.199 - 188.8.131.52
- Oracle 12c (Release 1): 184.108.40.206 - 220.127.116.11.0
If running on one of the above releases, it is recommended to always install the latest patch-set.
Oracle 9iR2 was desupported on 31 July 2007. However, customers on Oracle 18.104.22.168 received free Extended Support until July 31, 2008. For details about this, see http://www.oracle.com/features/hp/database-9i-support.html