Just read the Oracle XE license information

The list of what EXTRA options/features you can actually use is looooong. Since it don’t like lists that includes the word “No” I created an only “Yes” list. Really looking forward to start working on more than one these topics 🙂

Consolidation
Oracle Multitenant Max 3 PDBs

Development Platform
SQLJ
Microsoft Distributed Transaction Coordinator support Windows only
Native .NET Data Provider—ODP.NET Windows only
.NET Stored Procedures

High Availability
Online index rebuild
Online table organization
Online table redefinition
Trial recovery
Fast-start fault recovery
Flashback Table
Flashback Database
Cross-platform Backup and Recovery

Intergration
Sharded Queues

Networking
Network Compression

Performance
Client Side Query Cache
Query Results Cache
PL/SQL Function Result Cache
Adaptive Execution Plans
In-Memory Column Store
In-Memory Aggregation
Attribute Clustering

Security
Column-Level Encryption
Tablespace Encryption *See Oracle Advanced Security Guide for details
Oracle Advanced Security
Oracle Database Vault
Oracle Label Security
Centrally Managed Users
Fine-grained auditing
Privilege Analysis
Real Application Security
Redaction
Transparent Sensitive Data Protection
Virtual Private Database

Spatial and Graph Data
Oracle Spatial and Graph
Property Graph and RDF Graph Technologies (RDF/OWL)
Partitioned spatial indexes

VLDB, Data Warehousing, and Business Intelligence
Oracle Partitioning
Oracle Advanced Analytics
Oracle Advanced Compression
Advanced Index Compression
Prefix Compression (also called Key Compression)
Basic Table Compression
Deferred Segment Creation
Bitmapped index, bitmapped join index, and bitmap plan conversions
Transportable tablespaces, including cross-platform and full transportable export and import
Summary management—Materialized View Query Rewrite

source

Over & Out