Features not included in Oracle 11g Express Edition

The other day I was trying to get the Query Results Cache working on Oracle 11g Express Edition (XE) without realizing that this features and a bunch of others are not included in the express edition. I had a brief Aha moment! Now, if something doesn't work in XE as expected, I will be sure to check the list below.

Anyway, this is what I was trying to get to work and note that the below query is not using the result cache as expected:

result_cache_max_size is set to 10MB.

SQL> set autotrace traceonly
SQL> select /*+ RESULT_CACHE */  month_id, item_id, sum(sales), sum(cost) from global.U

3567 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 1581584384

-------------------------------------------------------------------------------------
| Id  | Operation          | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |                |  1744K|    64M|  3672   (3)| 00:00:45 |
|   1 |  HASH GROUP BY     |                |  1744K|    64M|  3672   (3)| 00:00:45 |
|   2 |   TABLE ACCESS FULL| UNITS_FACT_BAK |  1744K|    64M|  3597   (1)| 00:00:44 |
-------------------------------------------------------------------------------------

Note
-----
   - dynamic sampling used for this statement (level=2)


Statistics
----------------------------------------------------------
          4  recursive calls
          0  db block gets
      13272  consistent gets
      13177  physical reads
          0  redo size
     144662  bytes sent via SQL*Net to client
       3026  bytes received via SQL*Net from client
        239  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       3567  rows processed

Here is a complete list of all options NOT INCLUDED in Oracle 11g Express Edition (XE)

http://docs.oracle.com/cd/E17781_01/license.112/e18068/toc.htm#BABJIJCJ

Excerpt from documentation as a quick reference:

2.1 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
    
    If you are interested, here is a video from OTN.
    Oracle Database Express Edition Goes to 11!