X

Enabling Real-Time Analytics With Database In-Memory

Analytics In The Cloud

Andy Rivenes
Product Manager

With the introduction of Oracle Database Exadata Express Cloud Service I thought it would be nice to review where Database In-Memory is offered in Oracle's cloud services. The Oracle Cloud not only offers customers an easy and cost effective way to deploy their applications in the cloud, but it also allows customers to easily try out Oracle options that they might not have otherwise licensed. In the case of Oracle Database Exadata Express Cloud Service it is possible to not only try out Oracle Database 12.2 but also the new 12.2 features of Database In-Memory with the X50IM option. The Oracle Database Exadata Express Cloud Service can be an excellent entry level environment for a test or development system.

Oracle offers three database cloud services that have options for Database In-Memory:

  • Oracle Database Cloud Service (Extreme Performance)
  • Oracle Database Exadata Cloud Service (quarter, half, full rack)
  • Oracle Database Exadata Express Cloud Service (XIM50 option)
Currently the Oracle Database Cloud Service and Oracle Database Exadata Cloud Service options support Database In-Memory on Oracle Database 12.1.0.2. The Oracle Database Exadata Express Cloud Service supports Database In-Memory on Oracle Database 12.2 with the XIM50 option.

So what do the configurations of the different options look like?

Oracle Database Cloud Service (Extreme Performance)

Runs 12.1.0.2 with Database In-Memory. Only limitations are how much CPU and memory you purchase.

Oracle Database Exadata Cloud Service

Runs 12.1.0.2 with Database In-Memory. Only limitations are how much CPU and memory is available in each configuration (e.g. quarter, half or full rack of Exadata).

Oracle Database Exadata Express Cloud Service

X50IM option only:

•    Single PDB running 12.2
•    No parallel query supported
•    Maximum 5 GB column store
•    In-Memory Join Groups limited to a maximum of 5 columns per group*
•    In-Memory Expressions only STATIC_ONLY and DISABLE settings are supported for INMEMORY_EXPRESSIONS_USAGE initialization parameter*

* See the Oracle Database Exadata Express Cloud Service Feature Restrictions and Limitations documentation for more information

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.