How to find out which Enterprise Edition features are being used in your oracle database ?

 How to find out which Enterprise Edition features are being used in your oracle database ?

I have seen many customer uses Enterprise Edition features unknowingly. They fall into trouble when Oracle performs an audit into their database and find out what are features they have using without their knowledge. As many of those features require extra cost.

A few of EE features that require extra licensing such as 

• Oracle Partitioning
• Oracle Label Security
• Oracle On-Line Analytical Processing (OLAP)
• Oracle Advanced Security
• Oracle Advanced Compression
• Oracle Database Vault
• Oracle Database In-Memory
• Oracle Active Data Guard
• Oracle Multitenant 
• Oracle Spatial and Graph

We can use following query to find out if any features that are being used cost extra.

spool DB_features_usage.lst Set feedback off Set lines 222 Col name  format a50 heading "Feature" Col version  format a10 heading "Version" Col detected_usages  format 999,990 heading "Detected|usages" Col currently_used    format a06     heading "Curr.|used?" Col first_usage_date  format a10     heading "First use" Col last_usage_date   format a10     heading "Last use" Col nop noprint Break on nop skip 1 on name SQL> Select decode(detected_usages,0,2,1) nop,  name, version, detected_usages, currently_used,   to_char(first_usage_date,'DD/MM/YYYY') first_usage_date,     to_char(last_usage_date,'DD/MM/YYYY') last_usage_date    from dba_feature_usage_statistics     order by nop, 1, 2;

This would save the output in a file by name DB_features_usage.lst.

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dblic/Licensing-Information.html#GUID-AB354617-6614-487E-A022-7FC9A5A08472