Skip to Main Content
Boost Analytics Performance with Oracle Database In-Memory

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 series of labs uses Oracle Database 21c to demonstrate how Database In-Memory is orders of magnitude faster than the traditional row store. Labs will show how to get started with Database In-Memory, how to populate and administer the IM column store, and how to run queries including joins and aggregations. It also highlights new features available in Oracle Database 21c that improve the performance of JSON applications and allow the contents of the IM column store to be automatically managed.

Workshop Info

1 hour, 30 minutes
  • Setup the lab environment
  • Enable In-Memory and populate the IM column store
  • Query the IM Column Store
  • Joins and Aggregation
  • JSON with Database In-Memory
  • Automatic In-Memory to automatically manage the IM column store
  • Familiarity with Database is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like