Oracle Express Edition – features new to 18cXE

I learned a number of things watching the recently concluded Women’s Soccer World Cup.

  • it is possible for a human body to be fouled in the penalty area without then falling over as if it has just been shot (see Lisa-Marie Utland for Norway against England for proof)
  • England have developed a happy knack of reaching the Semi-Final of every tournament they enter
  • Alex Morgan is a tea-drinker

There were some complaints that Morgan’s celebration of her goal against England were disrespectful. Personally, I though it was rather witty. Let’s face it, if she’d really want to stir up some controversy, she’d have mimed putting the milk in first.
That said, she is going to face a challenge at the Olympics next year were she may herself up against a united Great Britain team.
If you’re not up on your sporting geopolitics, Great Britain (for now at least) comprises four nations – England, Wales, Northern Ireland and Scotland.
Should Morgan need to celebrate in a similar vein, the tea will be just the start. She’ll then need to neck a pint of Brains SA (known as “Skull Attack” in Cardiff) followed by a Guinness ( there is no border in Ireland when it comes to the Black Stuff) before moving on to a Scotch single-malt chaser.

Anyone looking for an object lesson in how to up their game could do far worse than have a look at how Oracle Express Edition has evolved from 11g to 18c…

“Hey Megan, how much extra stuff did Oracle squeeze into 18c Express Edition ?”

Using the License documentation for 18c XE and that of 11g XE, I’ve compiled a list of features which are now included in Express Edition but were not in 11gXE.
This is mainly for my own benefit as I keep being surprised when I find another – previously Enterprise Edition only – feature in Express Edition.
I’ve also listed the new stuff that wasn’t previously available in any edition of Oracle 11g.

Anyhow, for anyone who might find it useful…

Extra functionality in 18c

Using the Functional Categories mentioned in the license documents as a template, the features newly available in 18c Express Edition are :

Consolidation

Perhaps the most profound structural change is the advent of Multitenant functionality.
18c XE comes with Oracle Multitenant and allows up to three Pluggable Databases (PDBs).

Development Platform

SQLJ is now available.

High Availability

  • Online Index Rebuild
  • Online table organization
  • Online table redefinition
  • Trial recovery
  • Fast-start fault recovery
  • Flashback Table
  • Flashback Database
  • Cross-platform Backup and Recovery

Integration

Sharded Queues have been introduced in Oracle since 11g.

Networking

Network Compression is also new to Oracle since 11g.

Performance

  • Client Side Query Cache
  • Query Results Cache
  • PL/SQL Function Result Cache
  • Adaptive Execution Plans
  • In-Memory Column Store
  • In-Memory Aggregation
  • Attribute Clustering

Security

  • Column-Level Encryption
  • Tablespace Encryption
  • Oracle Advanced Security
  • Oracle Database Vault
  • Oracle Label Security
  • Centrally Managed Users
  • Fine-grained auditing
  • Privilege Analysis
  • Real Application Security
  • Redaction
  • Transparent Sensitive Data Protection
  • Virtual Private Database

Spatial and Graph Data

11g XE contained no spatial functionality at all. In 18c you get :

  • Oracle Spatial and Graph
  • Property Graph and RDF Graph Technologies (RDF/OWL)
  • Partitioned spatial indexes

VLDB, Data Warehousing, and Business Intelligence

  • Oracle Partitioning
  • Oracle Advanced Analytics
  • Oracle Advanced Compression
  • Advanced Index Compression
  • Prefix Compression (also called Key Compression)
  • Basic Table Compression
  • Deferred Segment Creation
  • Bitmapped index, bitmapped join index, and bitmap plan conversions
  • Transportable tablespaces, including cross-platform and full transportable export and import
  • Summary management—Materialized View Query Rewrite

Stuff that’s not included

Unlike it’s predecessor, 18cXE does not come with a version of Application Express (APEX). Fortunately, you can still get APEX and Oracle Rest Data Services for the same low, low price of – well, nothing – and install them separately.

3 thoughts on “Oracle Express Edition – features new to 18cXE

  1. Being pedantic, Great Britain is only 3 countries (Wales, Scotland and England), whereas the United Kingdom is Great Britain + Northern Ireland.

    • Boneist,

      you are correct, of course.
      For some reason however, the Olympic teams from the United Kingdom compete as “Great Britain”. I’ve amended the post to clarify that I’m talking about sporting geopolitics.

      Mike

  2. Pingback: مزیت Oracle Database 18c XE برای اوراکل ای‌پکس - شرکت پایا شتابان اندیشه(APEXRAD)

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.