Skip to Main Content
Database In-Memory Advanced Features

About This Workshop

Youtube Video

About This Workshop
Oracle Database In-Memory provides a unique dual-format architecture that enables tables to be simultaneously represented in memory using traditional row format and a new in-memory column format. This lab demonstrates how to use Database In-Memory's advanced features to further increase analytic performance for application SQL without requiring any code changes. For an introduction to Database In-Memory see the lab "Boost Analytics Performance with Oracle Database In-Memory". This lab builds on that lab adding the performance and administrative features that have been added to Database In-Memory since its introduction. Features like Automatic In-Memory, In-Memory Expressions, Join Groups, In-Memory Hybrid scans and much more will be demonstrated.

Workshop Info

1 hour
  • Setup the lab environment
  • Enable In-Memory and populate the IM column store
  • In-Memory Expressions
  • Join Groups
  • In-Memory Optimized Arithmetic
  • JSON and the In-Memory column store
  • In-Memory External Tables
  • In-Memory Full Text Columns
  • In-Memory Spatial
  • In-Memory Hybrid Scans
  • Automatic In-Memory
  • Automatic In-Memory Level High
  • In-Memory Parallel Features

 

  • Familiarity with Database is required
  • Understanding of database terms and architectures is helpful
  • Familiarity with SQL and sqlplus is helpful
     

Other Workshops you might like

Ask Oracle
Helping you on LiveLabs
Powered by Oracle Digital Assistant and Oracle Generative AI