Oracle10g has auditing to tell if you have been
querying the Oracle10g Automated Session History views, an
extra-cost option according to sources at Oracle. The
DBA_FEATURE_USAGE_STATISTICS and
DBA_HIGH_WATER_MARK_STATISTICS views tell if you have been
using specific Oracle features.
Enterprise Edition Features |
|
|
|
|
|
|
|
|
|
11g new feature not in SE |
|
|
|
|
12c
new feature not in SE |
|
|
|
|
|
|
|
|
|
Consolidation |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Multitenant |
Y |
|
|
N |
Storage snapshot optimization |
|
|
|
N |
|
|
|
|
|
High Availability |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Application Continuity |
|
|
|
N |
RAC One Node |
Y |
|
|
N |
Data Guard - redo apply (physical standby) |
Y |
N |
N |
N |
Data Guard - SQL apply (logical standby) |
Y |
N |
N |
N |
Data Guard - Snapshot Standby |
Y |
|
N |
N |
Active Data Guard |
Y |
|
N |
N |
Data guard network compression |
|
|
N |
|
Rolling Upgrades |
|
N |
N |
N |
Rolling upgrades - using active data guard |
|
|
|
N |
Fast start selectable recovery time |
|
N |
|
|
Fast start fault recovery |
|
|
N |
N |
Online index rebuild |
|
|
N |
N |
IOT reorganization |
|
|
N |
N |
Duplexed backup sets |
|
|
|
N |
Block change tracking for fast incremental backup |
|
|
|
N |
Unused block compression in backups |
|
|
|
N |
Block level media recovery |
|
|
|
N |
Lost write protection |
|
|
|
N |
Automatic block repair |
|
|
|
N |
dbms_redefinition |
|
N |
N |
|
Flashback table |
|
N |
N |
N |
Flashback Database |
Y |
N |
N |
N |
Flashback transaction |
|
|
N |
N |
Optimization for Flashback Data Archive |
|
|
|
N |
Flashback transaction query |
|
N |
N |
N |
Flashback Data Archive (total recall) |
|
|
N |
|
Online datafile move |
|
|
|
N |
Transaction guard |
|
|
|
N |
Cross platform backup and recovery |
|
|
|
N |
Global Data Services |
|
|
|
N |
Block-level Media Recovery |
|
N |
N |
N |
Unused block compression in backups |
|
|
N |
N |
Parallel backup & recovery |
|
N |
N |
N |
Fast RMAN Compression (ZLIB) |
|
|
N |
N |
Point-in-time tablespace recovery |
|
N |
N |
N |
Trial recovery |
|
N |
N |
N |
Recovering tables from RMAN backups |
|
|
|
N |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Scalability |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Real Application Clusters (RAC) |
Y |
Y |
Y |
Y |
Quality of service management |
|
|
|
N |
Support for Exadata storage server |
|
|
N |
N |
In memory database cache |
|
|
N |
|
Concurrent execution of UNION branches |
|
|
|
N |
In
memory column store |
Y |
|
|
N |
Fault tolerant in memory column store |
|
|
|
N |
In
memory aggregation |
|
|
|
N |
Attribute clustering |
|
|
|
N |
Zone maps |
Y |
|
|
N |
Adaptive execution plans |
Y |
|
|
N |
|
|
|
|
|
Security |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Advanced Security option |
Y |
N |
N |
N |
Database vault |
Y |
|
|
N |
Oracle Label Security |
Y |
N |
N |
N |
Enterprise security |
Y |
|
|
N |
Data Masking Pack |
Y |
|
N |
|
Virtual Private Database |
Y |
N |
N |
N |
Fine Grained Auditing |
Y |
N |
N |
N |
Privilege analysis |
|
|
|
N |
Real Application Security |
|
|
|
N |
Redaction |
|
|
|
N |
Transparent sensitive data protection |
|
|
|
N |
Secure Application Role |
|
|
N |
|
|
|
|
|
|
Performance |
Detect? |
SE 10g |
SE 11g |
SE 12c |
PL/SQL function result cache |
|
|
N |
N |
Times Ten application-tier database cache |
|
|
|
N |
Database smart flash cache |
Y |
|
|
N |
Client-side query cache |
Y |
|
N |
N |
Query result cache |
Y |
|
|
N |
|
|
|
|
|
Manageability |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Change Management Pack |
Y |
N |
N |
|
Configuration Management Pack |
Y |
N |
N |
|
Cloud management pack |
Y |
|
|
N |
Data Masking Pack and sub-setting |
Y |
|
|
N |
Lifecycle management pack |
Y |
|
|
N |
Diagnostic Pack |
Y |
N |
N |
N |
Tuning Pack |
Y |
N |
N |
N |
Provisioning and Patch automation pack |
Y |
|
N |
|
Duplexed backup sets |
|
N |
N |
|
Database Resource Manager |
|
N |
N |
N |
Instance caging |
Y |
|
|
N |
SQL Plan management |
Y |
|
N |
N |
Rapid Home provisioning |
|
|
|
N |
|
|
|
|
|
VLDB, Data Warehousing, BI |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Partitioning option |
Y |
N |
N |
N |
OLAP option |
Y |
N |
N |
N |
Advanced analytics |
Y |
|
N |
N |
Advanced compression |
Y |
|
|
N |
Advanced index compression |
Y |
|
|
N |
Prefix compression (key compression) |
|
|
|
N |
Hybrid columnar compression |
|
|
|
N |
Exadata flash cache compression |
|
|
|
N |
Heat maps |
|
|
|
N |
automatic data optimization |
|
|
|
N |
basic table compression |
Y |
|
|
N |
Deferred segment creation |
|
|
|
N |
Direct Load data compression |
|
|
N |
|
OLTP compression |
|
|
N |
|
Data Mining Option |
|
N |
|
|
Data Compression |
Y |
N |
|
|
Bitmap index & bitmap join index |
Y |
N |
N |
N |
Parallel query/ DML |
Y (partial) |
N |
N |
N |
Parallel CBO statistics gathering |
|
N |
N |
N |
Parallel index builds/scans |
|
N |
N |
N |
Parallel data pump export/import |
|
N |
N |
N |
In-memory parallel execution |
|
|
|
N |
Parallel statement queueing |
|
|
|
N |
Parallel capture and apply via Xstream |
|
|
|
N |
Data Pump Compression |
|
|
N |
|
Export transportable tablespaces |
Y |
|
N |
|
Transportable tablespaces |
Y |
N |
|
N |
Materialized views - query rewrite |
Y |
N |
N |
N |
Asynchronous Data Change Capture |
|
N |
N |
|
Query rewrite cache |
|
|
N |
|
|
|
|
|
|
Integration |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Oracle Streams |
Y |
N |
Y |
Y |
Messaging gateway |
|
N |
N |
N |
Sharded queues |
Y |
|
|
N |
Advanced Replication |
Y |
N |
N |
N |
Distributed queries |
Y |
N |
Y |
|
|
|
|
|
|
Networking |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Connection Manager (CMAN) |
|
N |
N |
N |
infiniband Support |
|
N |
N |
N |
|
|
|
|
|
Spatial and Graph Data |
Detect? |
SE 10g |
SE 11g |
SE 12c |
Oracle Spatial |
Y |
N |
N |
N |
Semantic Technologies (RDF/OWL) |
|
|
N |
N |
Network Compression |
|
|
|
N |
Network encryption (SSL/TLS) |
|
|
|
N |
Parallel spatial index builds |
|
|
|
N |
Multimaster replication of SDO_GEOMETRY objects |
|
|
|
N |
Partitioned spatial indexes |
|
|
|
N |
It is imperative that the Oracle professional
understand the features and options within the bewildering
array of Oracle software offerings. By choosing the
correct options, Oracle pros can save their company
thousands of dollars and ensure that they have the right
software for their application.