Ameer Khan

 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;