Oracle 11g Enterprise Edition and Standard edition features comparison

Written by Kokei's Blog
Posted May 7, 2011 at 11:57 PM

Knowing the Oracle features are important for people who are constantly working with Oracle database. From time to time, I have been asking about the functions that Oracle can provide and compare the different features between Oracle editions during different phases of database project.

Here is a short lists of important Oracle features that are only available in Oracle 11g Enterprise edition but not Standard/Standard one. Most of this features are used to provide high availability and performance which are useful especially when you are administrating a large and mission-critical databases

1. All dataguard features

-Physical,Logical and Active dataguard(needs extra license) are only available in Enterprise editiion.

2. Online maintenance

-online index rebuild, online IOT rebuild, online table redefinition.

3. RMAN features

-Block tracking incremental backup, block-level media recovery,parallel backup and recovery, tablespace point-in-time recovery, duplexed backup sets, unused block compression.

4. Flashback features
-Flashback Table, Flashback Database, Flashback Transaction, Flashback Transaction Query.

5. Query cache
-Client Side query cache, Query Results cache, PL/SQL Function Result cache

6. Fine-grained auditing

7. Oracle Database Vault (Requires extra license)

8. Advanced Security option(Requires extra license)

9. Partitioning

-Need to pay extra license even under Enterprise Edition

10. Compression

-Basic Table Compression

-Advanced Compression(requires separate license):DML, RMAN, Datadump, SecureFiles and redo log(Dataguard) transport compression.

11. Parallelism

-Parallel query/DML, Parallel statistics gathering, Parallel index build/scans,Parallel DataPump, Parallel in-memory execution.

12. Export Transportable tablespaces

-Standard edition can only perform transportable tablespaces import, not export.

13. Updateable MV

-Standard versions only support readonly materialized view.

14. Multi-master replication

15. Oracle Streams

-Standard cannot perform redo capture

16. Oracle RAC One Node

17. Oracle Diagnostic Pack(Requires extra license)

18. Oracle Tuning Pack(Requires extra license, also requires the Diagnostic Pack

19. Database Resource Manager

20. SQL Plan Management

21. Oracle OLAP(Requires extra license)

22. Oracle Data Mining(Requires extra license)

23. Bitmapped index, bitmapped join index, and bitmap plan conversions

To determine what Oracle features you have used in a Oracle Enterprise Edition databae, you can query dba_feature_usage_statistics

Set linesize 300

Col name format a50

Col version format a10

Col currently_used format a10

Col first_used format a20

Col last_used format a20

Select name, version, detected_usages, currently_used,

to_char(first_usage_date,'HH24:Mi DD/MM/YYYY') first_used,

to_char(last_usage_date,'HH24:Mi DD/MM/YYYY') last_used

from dba_feature_usage_statistics

order by 1, 2