Oracle Database Editions & Oracle Features

Hi,

I will explain Oracle Database Editions and Oracle Features in this article.

If you want to learn the history and features of Oracle Database, you can read the following article.

 

 

Oracle Editions

There are 4 different versions for Oracle database usage purpose, features and license prices.

These versions and details are as follows.

  1. Enterprise Edition:  It is the most expensive version of Oracle database, which includes all components and options. This version is generally preferred by organizations that need business critical, high performance and extra security.
  2. Standart Edition: In organizations that do not need to use Enterprise edition, this version is usually used. This edition is not as expensive as an enterprise edition, as there are no features and components in the Enterprise edition.
  3. Personal Edition: Personal edition is a single-user version for development purposes.
  4. Express Edition: It is an entry-level version of Oracle Database that is easy to download, install and manage quickly, and is free to develop, deploy, and use. Data size and RAM usage limitation is not recommended because it is not recommended for commercial use because this version is free.

 

Detail features and option accoring to Oracle editions are as follows.

Feature/Option
SE1
SE
EE
Notes
High Availability
Oracle Fail SafeYYYWindows only
Oracle Data Guard—Redo ApplyNNY
Oracle Data Guard—SQL ApplyNNY
Oracle Data Guard—Snapshot StandbyNNY
Oracle Active Data GuardNNYExtra cost option
Rolling Upgrades—Patch Set, Database, and Operating SystemNNY
Online index rebuildNNY
Online index-organized table organizationNNYALTER TABLE … MOVE ONLINE operations
Online table redefinitionNNYUsing the DBMS_REDEFINITION package
Duplexed backup setsNNY
Block change tracking for fast incremental backupNNY
Unused block compression in backupsNNY
Block-level media recoveryNNY
Lost Write ProtectionNNY
Parallel backup and recoveryNNY
Tablespace point-in-time recoveryNNY
Trial recoveryNNY
Fast-start fault recoveryNNY
Flashback TableNNY
Flashback DatabaseNNY
Flashback TransactionNNY
Flashback Transaction QueryNNY
Flashback Data Archive (Total Recall)NNYRequires Oracle Advanced Compression option
Scalability
Oracle Real Application ClustersNYYExtra cost with EE, included with SE
Automatic Workload ManagementNYYRequires Oracle Real Application Clusters
Performance
Client Side Query CacheNNY
Query Results CacheNNY
PL/SQL Function Result CacheNNY
In-Memory Database CacheNNYExtra cost option
SQL Plan ManagementNNY
Support for Oracle Exadata Storage ServerNNY
Support for Oracle Exadata Storage Server SoftwareNNY
Security
Oracle Advanced SecurityNNYExtra cost option
Oracle Label SecurityNNYExtra cost option
Virtual Private DatabaseNNY
Fine-grained auditingNNY
Oracle Database VaultNNYExtra cost option
Development Platform
SQLJYYYRequires Oracle Programmer
Oracle Developer Tools for Visual Studio .NETYYYWindows only
Microsoft Distributed Transaction Coordinator supportYYYWindows only
Active Directory integrationYYYWindows only
Native .NET Data Provider—ODP.NETYYYWindows only
.NET Stored ProceduresYYYWindows only
Manageability
Oracle Change Management PackNNYExtra cost option
Oracle Configuration Management PackNNYExtra cost option
Oracle Diagnostic PackNNYExtra cost option
Oracle Tuning PackNNYExtra cost option, also requires the Diagnostic Pack
Oracle Provisioning and Patch Automation PackNNYExtra cost option
Database Resource ManagerNNY
Oracle Real Application TestingNNYExtra cost option
VLDB, Data Warehousing, Business Intelligence
Oracle PartitioningNNYExtra cost option
Oracle OLAPNNYExtra cost option
Oracle Data MiningNNYExtra cost option
Oracle Advanced CompressionNNYExtra cost option
Direct-Load Table CompressionNNY
Bitmapped index, bitmapped join index, and bitmap plan conversionsNNY
Parallel query/DMLNNY
Parallel statistics gatheringNNY
Parallel index build/scansNNY
Parallel Data Pump Export/ImportNNY
Transportable tablespaces, including cross-platformNNYImport of transportable tablespaces supported into SE, SE1, and EE
Summary management—Materialized View Query RewriteNNY
Asynchronous Change Data CaptureNNY
Integration
Basic ReplicationYYYSE1/SE: read-only, updateable materialized view
Advanced ReplicationNNYMulti-master replication
Oracle StreamsYYYSE1/SE: no capture from redo
Database GatewaysYYYSeparate product license
Networking
Oracle Connection ManagerNNY
Infiniband SupportNNY
Content Management
Oracle Spatial and GraphNNYExtra cost option
Semantic Technologies (RDF/OWL)NNYRequires the Oracle Spatial and Graph option and the Oracle Partitioning option

 

 

When using Oracle Database, very much attention should be paid to licensing not required versions and features should not be used. Although the business critics and situations of each institution are different, it can be said in general. If you don’t need Disaster Recovery, you don’t need to use Enterprise edition only if High availability is important if you don’t use features like Compression, parallelism and Encryption. Because many of the remaining features are already in the Standard edition, but the Real Application Cluster feature is in the Standard edition.

 

 

There are many examples and situations like this. Before installing Oracle Database, all needs and requirements should be determined and used accordingly. You should select which database components you will use after installation in the following Installation step.

One of the most misunderstood issues is the inclusion of all features and options in the Enterprise edition. That is to say, as I mentioned in the tables above of an enterprise with only Enterprise edition license, features such as Partitioning and Compression are not included in this license. Organizations using Enterprise edition have an Enterprise license for all features listed in the table above as Extra license costs, but are required to pay extra fees.

 

 

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 *