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
Consolidation
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Oracle Multitenant – # of PDBs | Y | Maximum of 3 PDBs |
| CDB Fleet Management | N | |
| PDB Snapshot Carousel | N | |
| Refreshable PDB switchover | N |
Development Platform
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| SQLJ | Y | |
| Microsoft Distributed Transaction Coordinator support | Y | Windows only |
| Native .NET Data Provider—ODP.NET | Y | Windows only |
| .NET Stored Procedures | Y | Windows only |
High Availability
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Application Continuity | N | |
| Oracle Sharding | N | |
| Oracle Fail Safe | N | |
| Oracle RAC One Node | N | |
| Oracle Data Guard—Redo Apply | N | |
| Oracle Data Guard—Far Sync Standby | N | |
| Oracle Data Guard—SQL Apply | N | |
| Oracle Data Guard—Snapshot Standby | N | |
| Oracle Data Guard—Real-Time Cascading Standbys | N | |
| Oracle Data Guard—Automatic Correction of Non-logged Blocks at a Data Guard Standby Database | N | |
| Oracle Active Data Guard | N | |
| Rolling Upgrades—Patch Set, Database, and Operating System | N | |
| Rolling Upgrades Using Active Data Guard | N | |
| Online index rebuild | Y | |
| Online table organization | Y | |
| Online table redefinition | Y | |
| Duplexed backup sets | N | |
| Block change tracking for fast incremental backup | N | |
| Unused block compression in backups | N | |
| Block-level media recovery | N | |
| Lost Write Protection | N | |
| Automatic Block Repair | N | |
| Parallel backup and recovery | N | |
| Tablespace point-in-time recovery | N | |
| Trial recovery | Y | |
| Fast-start fault recovery | Y | |
| Flashback Table | Y | |
| Flashback Database | Y | |
| Flashback Transaction | N | |
| Flashback Transaction Query | N | |
| Optimization for Flashback Data Archive | N | |
| Online Datafile Move | N | |
| Transaction Guard | N | |
| Cross-platform Backup and Recovery | Y | |
| Global Data Services | N | |
| Recovering tables and table partitions from RMAN backups | N |
Integration
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Oracle Streams | N | |
| Database Gateways | N | |
| Messaging Gateway | N | |
| Sharded Queues | Y |
Manageability
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Oracle Cloud Management Pack for Oracle Database | N | |
| Oracle Data Masking and Subsetting Pack | N | |
| Oracle Database Lifecycle Management Pack for Oracle Database | N | |
| Oracle Diagnostics Pack | N | |
| Oracle Tuning Pack | N | |
| Oracle Real Application Testing | N | |
| Database Resource Manager | N | |
| I/O Resource Management | N | |
| Instance Caging | N | |
| SQL Plan Management | N | |
| SQL Tuning Sets | N | |
| Rapid Home Provisioning | N |
Networking
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Infiniband support | N | |
| Oracle Connection Manager | N | |
| Network Compression | Y |
Performance
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Client Side Query Cache | Y | |
| Query Results Cache | Y | |
| PL/SQL Function Result Cache | Y | |
| Oracle TimesTen Application-Tier Database Cache | N | |
| Database Smart Flash Cache | N | |
| Support for Oracle Exadata Storage Server Software | N | |
| Adaptive Execution Plans | Y | |
Concurrent Execution of UNION and UNION ALL Branches | N | |
| In-Memory Column Store | Y | |
| In-Memory Column Cache on Storage Servers | N | |
| In-Memory Column Store on Active Data Guard standby | N | |
| Fault Tolerant In-Memory Column Store | N | |
| Automatic In-Memory Column Store | N | |
| In-Memory Column Store support for External Tables | N | |
| In-Memory Aggregation | Y | |
| MemOptimized Row Store | N | |
| Attribute Clustering | Y | |
| Zone Maps | N |
Scalability
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Oracle Real Application Clusters (Oracle RAC) | N | |
| Automatic Workload Management | N | |
| Quality of Service Management | N | |
| Oracle NoSQL Database Basic Edition | N |
Security
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Column-Level Encryption | Y | |
| Tablespace Encryption | Y | TDE online method to encrypt/rekey/decrypt an existing tablespace is not supported. See Oracle Advanced Security Guide for details |
| Oracle Advanced Security | Y | |
| Oracle Database Vault | Y | |
| Oracle Label Security | Y | |
| Enterprise User Security | N | |
| Centrally Managed Users | Y | |
| Fine-grained auditing | Y | |
| Privilege Analysis | Y | |
| Real Application Security | Y | |
| Redaction | Y | |
| Transparent Sensitive Data Protection | Y | |
| Virtual Private Database | Y | |
| Keystore for Each Pluggable Database | N |
Snapshots and Cloning
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Storage Snapshot Optimization | N |
Spatial and Graph Data
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Oracle Spatial and Graph | Y | |
| Property Graph and RDF Graph Technologies (RDF/OWL) | Y | |
| Parallel spatial index builds | N | |
Multimaster replication of SDO_GEOMETRY objects | N | |
| Partitioned spatial indexes | Y |
VLDB, Data Warehousing, and Business Intelligence
| Feature/Option/Pack | Availability | Notes |
|---|---|---|
| Oracle Partitioning | Y | |
| Oracle On-Line Analytical Processing (OLAP) | N | |
| Oracle Advanced Analytics | Y | |
| Oracle Advanced Compression | Y | |
| Advanced Index Compression | Y | |
| Prefix Compression (also called Key Compression) | Y | |
| Hybrid Columnar Compression | N | |
| Hybrid Columnar Compression Row-Level Locking | N | |
| Exadata Flash Cache Compression | N | |
| Heat Map | N | |
| Automatic Data Optimization | N | |
| Basic Table Compression | Y | |
| Deferred Segment Creation | Y | |
| Bitmapped index, bitmapped join index, and bitmap plan conversions | Y | |
| Parallel query/DML | N | |
| Parallel statistics gathering | N | |
| Parallel index build/scans | N | |
| Parallel Data Pump Export/Import | N | |
| In-memory Parallel Execution | N | |
| Parallel Statement Queuing | N | |
| Parallel capture and apply via XStream | N | |
| Transportable tablespaces, including cross-platform and full transportable export and import | Y | |
| Summary management—Materialized View Query Rewrite | Y |
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.