Understanding Oracle Licenses and Database versions

The Oracle Database 11g full reference manual contains the contents of the license, as follows:

The first step in using the software is to successfully install the software. If you do not consider installing Oracle's hardware and software platforms, you can choose the same type of installation.

Although the types between different versions are not exactly the same, they generally include the following: Enterprise Edition (Enterprise Edition): This version is the most fully functional Oracle database, the best scalable version. It contains features such as the Flashback database (Flash back) and allows you to add other features that have been purchased for licenses, such as Oracle Spatial, Oracle OLAP, Oracle Label Security, and Oracle Data Mining Standard Edition (Standard Edition): This version provides a good subset of features for the Enterprise Edition, often containing the features required by small companies Personal Edition (Personal Edition): This release allows you to develop applications that will run on standard or Enterprise editions. It cannot be used to develop commercial products

Only the specified user or CPU can obtain permission from the Oracle database, and multiple users cannot use the same license at the same time. Therefore, the DBA should use the initialization parameter license_max_users to specify the maximum number of users that can be created in the database. In addition, Oracle Management server (the backend for Oracle Enterprisemanager (OEM) clients) can install the server-side or client-side. However, it is best to perform this installation after the basic installation of the database is complete.

The above general introduction of several commonly used versions, O friends to understand the above content can also, if you want to be more detailed understanding, you can read the official note, below I provide 10g R2 and 11g R2 Fast index.

Official Note:

11g R2:

Http://docs.oracle.com/cd/E11882_01/license.112/e10594/editions.htm

10g R2:

Http://docs.oracle.com/cd/B19306_01/license.102/b14199/editions.htm

Oracle databases are actually available in 5 versions, detailed below:

The Oracle Database Product Family

Oracle Database is available in fiveeditions, each suitable for different development and deployment. Oracle also offers several database options, packs, and other products thatenhance the capabilities of Oracle database for Specific purposes. This sectiondescribes the Oracle Database editions.

Oracle Database Standard editionone Oracle Database Standard Edition onedelivers Unprecedented ease of use, power, and performance for Workgroup,department-le Vel, and WEB applications. From Single-server environments Forsmall business to highly distributed branch environments, Oracle Databasestandard Editi On one includes all of the facilities necessary to buildbusiness-critical applications.

Oracle Database Standard Edition Oracle Database Standard Edition delivers the unprecedented ease ofuse, power, and performance of Standard Edition one, WI TH support for largermachines and clustering to services with Oracle Real application clusters (Oracle RAC). Oracle RAC isn't included in the Standard Edition of Releasesprior to Oracle Database 10g, nor are it an available option With those earlierreleases.

Oracle Database Enterprise Edition Oracle Database Enterprise Edition provides the performance,availability, scalability, and security required for MISSION-C Riticalapplications such as High-volume online transaction processing (OLTP) applications, query-intensive data Warehouses, and demanding internetapplications.

Oracle Database expressedition Oracle Database Express Edition (Oracle database XE) is a entry-level Edition of Oracle database this is quickto download Simple to install and manage, and are free to develop, deploy, anddistribute. Oracle Database XE makes it easy to upgrade to the other editionsof Oracle without costly and complex migrations. Oracle Database XE can beinstalled on any size machine and any number of CPUs, stores up to 4GB of UserData, using the up to 1GB of memory, and using only one CPU on the host machine. Support is provided by a online forum.

Oracle Database Personal Edition Oracle Database Personal Edition supports Single-user Developmentand deployment environments that require full Compatibili Ty with Oracledatabase Standard Edition one, Oracle Database Standard Edition, and Oracledatabase Enterprise Edition.

Personal Edition includes all of thecomponents this are included with Enterprise Edition, as as a all of theoptions tha T are available with Enterprise Edition, with the exception of Theoracle real application clusters option, which cannot is Used with Personaledition. Personal Edition is available to Windows and Linux platforms only. The Management packs are not included in Personal Edition.

In addition, each of these versions supports a different component, and the following table is for three versions, where SE1 represents Oracle Database Standard Edition One, se represents oracledatabase Standard Edition, EE represents Oracle Database Enterprise Edition, and Y indicates that the component is available in one version, and n indicates not available.

By using the table below, we can see the differences between versions at a glance and let us quickly locate the best version that suits our company.

Feature availability for oracledatabase Editions

/tr>

feature/option	SE1	SE	EE	Notes
High availability
Oracle Fail Safe	Y	Y	Y	Windows only
Oracle RAC One Node	N	N	Y	Extra Cost option
Oracle Data Guard-redo Apply	N	N	Y
Oracle Data Guard-sql Apply	N	N	Y
Oracle Data Guard-snapshot Standby	N	N	Y
Oracle Active Data Guard	N	N	Y	Extra Cost option
Rolling Upgrades-patch Set, Database, and operating System	N	N	Y
Online Index Rebuild	N	N	Y
Online index-organized Table Organization	N	N	Y	ALTER TABLE ... Move ONLINE Operations
Online table redefinition	N	N	Y	Using the Dbms_redefinition Package
Duplexed Backup Sets	N	N	Y
Block change tracking for fast incremental backup	N	N	Y
Unused block compression in backups	N	N	Y
Block-level Media Recovery	N	N	Y
Lost Write Protection	N	N	Y
Automatic Block Repair	N	N	Y	Requires Oracle Active Data Guard option
Parallel Backup and Recovery	N	N	Y
Tablespace point-in-time Recovery	N	N	Y
Trial Recovery	N	N	Y
Fast-start Fault Recovery	N	N	Y
Flashback Table	N	N	Y
Flashback Database	N	N	Y
Flashback Transaction	N	N	Y
Flashback Transaction Query	N	N	Y
Flashback Data Archive (Total Recall)	N	N	Y	Requires Oracle Advanced Compression option
Scalability
Oracle Real Application Clusters	N	Y	Y	Extra cost with EE, included with SE
Automatic Workload Management	N	Y	Y	Requires Oracle Real Application clusters
Quality of Service Management (measure-only Mode)	N	N	Y	Requires Oracle Real Application clusters Available starting with Oracle Database 11g Release 2 (11.2.0.3)
Performance
Client Side Query Cache	N	N	Y
Query Results Cache	N	N	Y
Pl/sql Function Result Cache	N	N	Y
In-memory Database Cache	N	N	Y	Extra Cost option
Database Smart Flash Cache	N	N	Y	Solaris and Oracle Linux only
Support for Oracle exadata Storage Server Software	N	N	Y
Security
Oracle Advanced Security	N	N	Y	Extra Cost option
Oracle Label Security	N	N	Y	Extra Cost option
Virtual Private Database	N	N	Y
Fine-grained auditing	N	N	Y
Oracle Database Vault	N	N	Y	Extra Cost option
Enterprise User Security	N	N	Y	End User security and password Authentication is a EE feature requiring OID to be licensed. End User authentication with strong authentication (PKI, Kerberos, Radius) are an EE feature requiring Oracle Advanced SECU Rity and OID to be licensed.
Development Platform
Sqlj	Y	Y	Y	Requires Oracle Programmer
Oracle Developer Tools for Visual Studio. NET	Y	Y	Y	Windows only
Microsoft distributed Transaction Coordinator support	Y