Oracle Express Edition (XE) 11g ( Avaliable

Oracle Database Express Edition 11g Release 2

Free to develop, deploy, and distribute

Oracle Database Express Edition 11g Release 2 (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base.  It’s free to develop, deploy, and distribute; fast to download; and simple to administer.

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.


Avaliable only to Windows x32 and Linux x64

Download Link:

Feature Availability

  • Options and Major Features Not Included
  • Application Development, Language, and Database Features
  • Availability/Backup and Recovery Features
  • Security Features
  • Manageability Features
  • Data Movement/Integration Features
  • Networking Features

Options and Major Features Not Included

The following options and major features are not included with Oracle Database XE:

  • Development Platform
    • Oracle Precompilers (Pro*C/C++, Pro*Cobol)
    • SQLJ
  • High Availability:
    • Automatic Block Repair
    • Block change tracking for fast incremental backup
    • Block-level media recovery
    • Duplexed backup sets
    • Fast-start fault recovery
    • Flashback Database
    • Flashback Data Archive
    • Flashback Table
    • Flashback Transaction
    • Lost Write Protection
    • Online index rebuild
    • Online index-organized table organization
    • Online table redefinition
    • Oracle Active Data Guard
    • Oracle Data Guard-Redo Apply
    • Oracle Data Guard-Snapshot Standby
    • Oracle Data Guard-SQL Apply
    • Oracle Fail Safe
    • Oracle RAC One Node
    • Parallel backup and recovery
    • Rolling Upgrades-Patch Set, Database, and Operating System
    • Tablespace point-in-time recovery
    • Trial recovery
    • Unused block compression in backups
    • Oracle Total Recall
  • Scalability
    • Automatic Workload Management
    • Oracle Real Application Clusters
  • Security
    • Advanced Security Option
    • Fine-grained auditing
    • Oracle Database Vault
    • Oracle Label Security
    • Oracle Virtual Private Database
    • Secure External Password Store
    • SecureFiles Encryption
  • Performance
    • Client Side Query Cache
    • Database Smart Flash Cache
    • In-Memory Database Cache
    • PL/SQL Function Result Cache
    • Query Results Cache
    • Server Flash Cache
    • Support for Oracle Exadata Storage Server Software
    • Xstream
  • Manageability
    • Database Resource Manager
    • Deferred segment creation
    • Instance Caging
    • Oracle Change Management Pack
    • Oracle Configuration Management Pack
    • Oracle Diagnostic Pack
    • Oracle Real Application Testing
    • Oracle Provisioning and Patch Automation Pack
    • Oracle Tuning Pack
    • SQL Plan Management
  • VLDB, Data Warehousing, Business Intelligence
    • Asynchronous Change Data Capture
    • Basic Table Compression
    • Bitmapped index, bitmapped join index, and bitmap plan conversions
    • Deferred Segment Creation
    • In-memory Parallel Execution
    • Oracle Advanced Compression
    • Oracle Data Mining
    • Oracle Data Profiling and Quality
    • Oracle Data Watch and Repair Connector
    • Oracle OLAP
    • Oracle Partitioning
    • Parallel Data Pump Export/Import
    • Parallel index build/scans
    • Parallel query/DML
    • Parallel Statement Queuing
    • Parallel statistics gathering
    • Summary management-Materialized View Query Rewrite
    • Transportable tablespaces, including cross-platform
  • Integration
    • Advanced Replication
    • Database Gateways
    • Messaging Gateway
    • Oracle Streams
  • Content Management
    • Oracle Multimedia
    • Semantic Technologies (RDF/OWL)
  • Spatial and Location Data
    • Multimaster replication of SDO_GEOMETRY objects
    • Oracle Spatial
    • Parallel spatial index builds
    • Partitioned spatial indexes
  • Networking
    • Infiniband Support
    • Oracle Connection Manager

Application Development, Language, and Database Features 

Feature Availability
SQL*Plus Yes
Integrated Web Application Development Environment Yes (Oracle Application Express, no Application Express application authentication using Oracle Application Server Single Sign-On)
Database Web services No
PL/SQL stored procedures and triggers Yes
PL/SQL server pages Yes
PL/SQL native compilation Yes
JDBC drivers Yes (client-side JDBC only)
Java support in the database No
Java Server Pages No
Java native compilation No
XML support in the database Yes (no JNDI, or Servlet support)
Native .NET data provider support Yes (Windows only)
ASP.NET Providers Yes (Windows only)
OLE DB support Yes (Windows only)
ODBC support Yes (Windows and UNIX)
.NET Stored Procedures Yes (Windows only)
Microsoft Distributed Transaction Coordinator support Yes (Windows only)
COM Automation No (Windows only)
Oracle Objects for OLE (OO4O) No (Windows only)
Windows VLM Support, 4GB RAM Tuning No (Windows only)
Large Page memory support Yes (Windows only)
Active Directory integration Yes (Windows only; no storing of tnsnsames.ora file in Active Directory)
DML triggers Yes
Database event triggers Yes
Instead-of triggers Yes
Index-organized tables Yes
Temporary table Yes
Data Compression No
Objects and Extensibility Yes
LOB (large object) support Yes
Oracle Text Yes (English/French Knowledge Bases not supplied, nor are the following features: RULE_CLASSIFIER, SVM_CLASSIFIER, and KMEAN_CLUSTERING)
Oracle Locator Yes
Function-based index Yes
Bitmapped index, bitmapped join index No
Regular Expressions Yes
Sample Scan Yes
SQL Model Yes
SQL Analytic functions Yes
Summary Management No
Materialized View Query Rewrite No
Star query transformation Yes (B-tree indexes only)
Parallel query/DML No
Parallel statistics gathering No
Parallel index build/scans No
Parallel export/import No
Globalization support Yes (limited character sets and language translations; seeOracle Database Express Edition Installation Guide)
Multiple block size support Yes

Availability/Backup and Recovery Features

Feature Availability
Drop column Yes
Rename column, constraint Yes
Online schema reorganization/redefinition No
Flashback Query Yes
Flashback Table No
Flashback Database No
Flashback Transaction Query No
Server-managed backup and recovery No
Online Backup Yes
Backup Unused Block Compression No
Backup Encryption No
Incremental backup and recovery Yes (no change tracking file or optimized incremental backup capability)
Duplexed backup sets No
Fast-Start Selectable Recovery Time No
Block-level media recovery No
Parallel backup and recovery No
Point-in-time tablespace recovery No
Trial recovery No
Rolling Upgrade Support – Patch Set, Database and O/S No
Oracle Logminer Yes

Security Features

Feature Availability
Encryption toolkit Yes
Virtual Private Database No
Fine grained auditing No

Manageability Features

Feature Availability
Automatic Storage Management No
Automatic Datafile Management Yes
Automatic Memory Management Yes
Automatic Undo Management Yes
Automatic Optimizer Statistics Management Yes
Server-generated Alerts Yes
Database Resource Manager No

Data Movement/Integration Features

Feature Availability
Direct Path Load API Yes
External tables Yes
External procedures Yes
Synchronous Change Data Capture No
Asynchronous Change Data Capture No
Transportable tablespaces, including cross-platform No
Advanced Queuing Yes
Basic Replication Yes (read-only and updateable materialized view site only)
Advanced Replication No
Distributed queries Yes
Distributed transactions Yes
Transparent Gateways No
Generic connectivity Yes

Networking Features

Feature Availability
Directory connectivity No

For more details:

Database Express Edition Documentation 11g Release 2 (11.2)



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s