Just another Blog

My Technical, Professional and at times Personal Blog

Showing posts with label Oracle 11g Express Edition Options Not Included. Show all posts

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!

Google+ Followers