This blog post is inspired on work I have been doing on Standard Edition databases and the returning confusion about what is and what is not part of Standard Edition.
DBA_FEATURE_USAGE_STATISTICS is a tool in determining license usage for the Oracle database. It is good to understand the implications of each entry, know what is happening in your database and thus be able to have a substantial conversation about the usage of your license, being SE, SEO, SE2 or EE!
This list is the full list of DBA_FEATURE_USAGE_STATISTICS and I have found no source where there is a mapping of these features to database editions. As it is a lot of tedious work I call upon the community to help complete the list and make it as accurate as can be. So, if you have news, improvements, other bits of information, please send it to me and I will make sure it gets added!
WARNING: Still… with all the work that goes into these answers, it is not the law, it is a very serious interpretation of facts which will pay a part in helping you make the right decision when it comes to database licensing.
| Feature | Standard Edition |
|---|---|
| Active Data Guard – Real-Time Query on Physical Standby | NO ! |
| ADDM | NO ! |
| Advanced Replication | NO ! |
| Application Express | YES |
| ASO native encryption and checksumming | NO – EE option ! |
| Audit Options | NO ! |
| Automatic Maintenance – Optimizer Statistics Gathering | YES |
| Automatic Maintenance – Space Advisor | YES |
| Automatic Maintenance – SQL Tuning Advisor | NO ! |
| Automatic Memory Tuning | |
| Automatic Segment Space Management (system) | YES |
| Automatic Segment Space Management (user) | |
| Automatic SGA Tuning | YES |
| Automatic SQL Execution Memory | YES |
| Automatic SQL Tuning Advisor | NO ! |
| Automatic Storage Management | |
| Automatic Undo Management | |
| Automatic Workload Repository | |
| AWR Baseline | NO ! |
| AWR Baseline Template | NO ! |
| AWR Report | NO ! |
| Backup BASIC Compression | |
| Backup BZIP2 Compression | |
| Backup Encryption | |
| Backup HIGH Compression | |
| Backup LOW Compression | |
| Backup MEDIUM Compression | |
| Backup Rollforward | |
| Backup ZLIB Compression | |
| Baseline Adaptive Thresholds | |
| Baseline Static Computations | |
| Bigfile Tablespace | |
| Block Media Recovery | NO ! |
| Change Data Capture | NO ! |
| Change-Aware Incremental Backup | |
| Character Semantics | |
| Character Set | |
| Client Identifier | |
| Clusterwide Global Transactions | |
| Compression Advisor | |
| Crossedition Triggers | |
| CSSCAN | |
| Data Guard | NO ! |
| Data Mining | NO – EE option ! |
| Data Recovery Advisor | |
| Database Migration Assistant for Unicode | |
| Database Replay: Workload Capture | NO ! 1 |
| Database Replay: Workload Replay | NO ! 1 |
| DBMS_STATS Incremental Maintenance | |
| Deferred Open Read Only | |
| Deferred Segment Creation | NO ! |
| Direct NFS | |
| Dynamic SGA | |
| Editioning Views | |
| Editions | |
| EM Database Control | |
| EM Grid Control | |
| EM Performance Page | |
| Encrypted Tablespaces | |
| Exadata | |
| Extensibility | |
| File Mapping | |
| Flashback Data Archive | NO ! 2 |
| Flashback Database | NO ! |
| GoldenGate | NO – EE option ! 3 |
| HeapCompression | |
| Hybrid Columnar Compression | NO ! |
| Instance Caging | NO ! |
| Internode Parallel Execution | |
| Job Scheduler | |
| Label Security | NO – EE option ! |
| LOB | |
| Locally Managed Tablespaces (system) | YES |
| Locally Managed Tablespaces (user) | |
| Locator | YES |
| Logfile Multiplexing | |
| Long-term Archival Backup | |
| Materialized Views (User) | NO ! |
| Messaging Gateway | NO ! |
| MTTR Advisor | |
| Multi Section Backup | |
| Multiple Block Sizes | |
| Object | |
| OLAP – Analytic Workspaces | NO – EE option ! |
| OLAP – Cubes | NO – EE option ! |
| Oracle Database Vault | NO – EE option ! |
| Oracle Java Virtual Machine (system) | YES |
| Oracle Java Virtual Machine (user) | |
| Oracle Managed Files | |
| Oracle Multimedia | |
| Oracle Multimedia DICOM | |
| Oracle Secure Backup | |
| Oracle Text | |
| Oracle Utility Datapump (Export) | |
| Oracle Utility Datapump (Import) | |
| Oracle Utility External Table | |
| Oracle Utility Metadata API | |
| Oracle Utility SQL Loader (Direct Path Load) | |
| Parallel SQL DDL Execution | NO ! |
| Parallel SQL DML Execution | NO ! |
| Parallel SQL Query Execution | NO ! |
| Partitioning (system) | YES |
| Partitioning (user) | NO – EE option ! |
| PL/SQL Native Compilation | |
| Quality of Service Management | NO ! |
| Read Only Tablespace | |
| Real Application Clusters (RAC) | YES 4 |
| Real-Time SQL Monitoring | |
| Recovery Area | |
| Recovery Manager (RMAN) | YES |
| Resource Manager | NO ! |
| Restore Point | |
| Result Cache | NO ! |
| RMAN – Disk Backup | |
| RMAN – Tape Backup | |
| Rules Manager | |
| SecureFile Compression (system) | YES |
| SecureFile Compression (user) | |
| SecureFile Deduplication (system) | YES |
| SecureFile Deduplication (user) | |
| SecureFile Encryption (system) | YES |
| SecureFile Encryption (user) | |
| SecureFiles (system) | YES |
| SecureFiles (user) | |
| Segment Advisor (user) | |
| Segment Shrink | |
| Semantics/RDF | NO ! |
| Server Flash Cache | |
| Server Parameter File | |
| Services | |
| Shared Server | |
| Spatial | NO – EE option ! |
| SQL Access Advisor | |
| SQL Monitoring and Tuning pages | NO – EE option ! |
| SQL Performance Analyzer | NO ! |
| SQL Plan Management | NO ! |
| SQL Profile | |
| SQL Repair Advisor | |
| SQL Tuning Advisor | |
| SQL Tuning Set (system) | YES |
| SQL Tuning Set (user) | |
| SQL Workload Manager | |
| Streams (system) | YES 5 |
| Streams (user) | |
| Transparent Data Encryption | |
| Transparent Gateway | YES – option |
| Transportable Tablespace | NO ! 6 |
| Tune MView | |
| Undo Advisor | |
| Very Large Memory | |
| Virtual Private Database (VPD) | NO ! 7 |
| Workspace Manager |
- Unless used for upgrade to Enterprise Edition.
- Unless used without history table optimization.
- Goldengate can also be used with Standard Edition, it is a separate product.
- RAC on Enterprise Edition is an option.
- No capture from redo.
- Import transportable tablespaces in all editions.
- Policies on XDB$ACL$xd_sp in sys.v_$vpd_policy are internal ( “out of the box”) policies that are used by XDB to control the access to certain internal tables. All the logic is implemented in the xdb.DBMS_XDBZ package and there is no way one can control / influence the way this is working.
Locator probably mean Oracle Locator, which is free subversion of Oracle Spatial. Oracle Locator is included in all oracle versions.
Hi Tomi,
Would your ‘probably’ be such an explicit ‘probably’ that it is 99,9%? – I’ll put it in 😉
Thank you.
Hello,
There are also a lot of features not available in SE that do not appear in this view. But they can be important in a license choice.
Rman multi channels, Rman block change tracking for incremental backup, online alter of tables or indexes …
Don’t know if they parts of some features listed there …
Regards,
—
Bertrand
Hi Bertrand,
Undoubtedly there is more than meets the eye. This is first step to shed light on the topic.
This initiative primarily is based on explaining the findings when you query DBA_FEATURE_USAGE_STATISTICS.
The approach, the other way around, as you are suggesting, is probably a bit more easy to find / interpret and choose on.
Nevertheless we then need to check of any of what you mention is in the catch of one of the lines of the table. Let’s investigate…
Regards,
Jan
Hi Jan,
The subject seems to be interesting a lot of people at the moment.
Here is a link to a post by Martin Berger about another approach of this view
http://berxblog.blogspot.fr/2015/11/anatomy-of-dbafeatureusagestatistics.html
At the bottom of the post you will find a link about a script provided by oracle to map dba_features and option packs. Don’t have had time to test it by myself at the moment , but it could be interesting.
Regards,
—
Bertrand
Hello,
Why does Job scheduler not in SE? I already tried and it can be used in SE2 19c.
Thank you,
Kulchart