Oracle Database XE 18c – Features and Restrictions

Oracle Database XE 18c – Resource Limitations

Here are the Oracle DB XE 18c resource limitations:

  • Up to 12 GB of user data
  • Up to 2 GB of database RAM
  • Up to 2 CPU threads
  • Up to 3 Pluggable Databases

Oracle Database XE 18c – Features, Options, and Management Packs

Summary List

Multitenant: Get isolation, agility, and economies of scale by managing multiple Pluggable Databases inside your Oracle Multitenant Container Database

In-Memory: Support real-time analytics, business intelligence, and reports by keeping your important data in the Oracle Database In-Memory column store

Partitioning: Enhance performance, availability, and manageability of your database with data partitioning that meets diverse business requirements

Advanced Analytics: Get valuable insights and deliver predictions from your data using Data Mining SQL, R programming, and the Oracle Data Miner UI

Advanced Security: Protect your sensitive data at the source and build end-to-end encrypted apps with layers of security including Oracle Transparent Data Encryption and Data Redaction

Oracle Database XE 18c – Features, Options, and Management Packs

Full List


Oracle Multitenant – # of PDBsYMaximum of 3 PDBs
CDB Fleet ManagementN
PDB Snapshot CarouselN
Refreshable PDB switchoverN


Development Platform

Microsoft Distributed Transaction Coordinator supportYWindows only
Native .NET Data Provider—ODP.NETYWindows only
.NET Stored ProceduresYWindows only


High Availability

Application ContinuityN
Oracle ShardingN
Oracle Fail SafeN
Oracle RAC One NodeN
Oracle Data Guard—Redo ApplyN
Oracle Data Guard—Far Sync StandbyN
Oracle Data Guard—SQL ApplyN
Oracle Data Guard—Snapshot StandbyN
Oracle Data Guard—Real-Time Cascading StandbysN
Oracle Data Guard—Automatic Correction of Non-logged Blocks at a Data Guard Standby DatabaseN
Oracle Active Data GuardN
Rolling Upgrades—Patch Set, Database, and Operating SystemN
Rolling Upgrades Using Active Data GuardN
Online index rebuildY
Online table organizationY
Online table redefinitionY
Duplexed backup setsN
Block change tracking for fast incremental backupN
Unused block compression in backupsN
Block-level media recoveryN
Lost Write ProtectionN
Automatic Block RepairN
Parallel backup and recoveryN
Tablespace point-in-time recoveryN
Trial recoveryY
Fast-start fault recoveryY
Flashback TableY
Flashback DatabaseY
Flashback TransactionN
Flashback Transaction QueryN
Optimization for Flashback Data ArchiveN
Online Datafile MoveN
Transaction GuardN
Cross-platform Backup and RecoveryY
Global Data ServicesN
Recovering tables and table partitions from RMAN backupsN



Oracle StreamsN
Database GatewaysN
Messaging GatewayN
Sharded QueuesY



Oracle Cloud Management Pack for Oracle DatabaseN
Oracle Data Masking and Subsetting PackN
Oracle Database Lifecycle Management Pack for Oracle DatabaseN
Oracle Diagnostics PackN
Oracle Tuning PackN
Oracle Real Application TestingN
Database Resource ManagerN
I/O Resource ManagementN
Instance CagingN
SQL Plan ManagementN
SQL Tuning SetsN
Rapid Home ProvisioningN



Infiniband supportN
Oracle Connection ManagerN
Network CompressionY



Client Side Query CacheY
Query Results CacheY
PL/SQL Function Result CacheY
Oracle TimesTen Application-Tier Database CacheN
Database Smart Flash CacheN
Support for Oracle Exadata Storage Server SoftwareN
Adaptive Execution PlansY
Concurrent Execution of UNION and UNION ALL BranchesN
In-Memory Column StoreY
In-Memory Column Cache on Storage ServersN
In-Memory Column Store on Active Data Guard standbyN
Fault Tolerant In-Memory Column StoreN
Automatic In-Memory Column StoreN
In-Memory Column Store support for External TablesN
In-Memory AggregationY
MemOptimized Row StoreN
Attribute ClusteringY
Zone MapsN



Oracle Real Application Clusters (Oracle RAC)N
Automatic Workload ManagementN
Quality of Service ManagementN
Oracle NoSQL Database Basic EditionN



Column-Level EncryptionY
Tablespace EncryptionYTDE online method to encrypt/rekey/decrypt an existing tablespace is not supported. See Oracle Advanced Security Guide for details
Oracle Advanced SecurityY
Oracle Database VaultY
Oracle Label SecurityY
Enterprise User SecurityN
Centrally Managed UsersY
Fine-grained auditingY
Privilege AnalysisY
Real Application SecurityY
Transparent Sensitive Data ProtectionY
Virtual Private DatabaseY
Keystore for Each Pluggable DatabaseN


Snapshots and Cloning

Storage Snapshot OptimizationN


Spatial and Graph Data

Oracle Spatial and GraphY
Property Graph and RDF Graph Technologies (RDF/OWL)Y
Parallel spatial index buildsN
Multimaster replication of SDO_GEOMETRY objectsN
Partitioned spatial indexesY


VLDB, Data Warehousing, and Business Intelligence

Oracle PartitioningY
Oracle On-Line Analytical Processing (OLAP)N
Oracle Advanced AnalyticsY
Oracle Advanced CompressionY
Advanced Index CompressionY
Prefix Compression (also called Key Compression)Y
Hybrid Columnar CompressionN
Hybrid Columnar Compression Row-Level LockingN
Exadata Flash Cache CompressionN
Heat MapN
Automatic Data OptimizationN
Basic Table CompressionY
Deferred Segment CreationY
Bitmapped index, bitmapped join index, and bitmap plan conversionsY
Parallel query/DMLN
Parallel statistics gatheringN
Parallel index build/scansN
Parallel Data Pump Export/ImportN
In-memory Parallel ExecutionN
Parallel Statement QueuingN
Parallel capture and apply via XStreamN
Transportable tablespaces, including cross-platform and full transportable export and importY
Summary management—Materialized View Query RewriteY

Additional Components

The following development platforms are not included with Oracle Database XE. You can download them separately and use them with XE

  • Oracle SQL Developer
  • Oracle Application Express (APEX)
  • Oracle Developer Tools for Visual Studio
  • Oracle REST Data Services (ORDS)

For more information please consult oracle Documentation.  Oracle Documentation is the source ofor the date used in this page also.