Sangam17 has ended
Please note: Agenda and speakers are subject to change.
Back To Schedule
Friday, December 8 • 11:25 - 12:15
Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS LIMITED

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Limited Capacity seats available

Session Abstract:

Originally introduced in Release, Database In-Memory (DBIM) offers the ability for analytic queries to sift through billions of rows at incredible speed because data is now retained in columnar format in the In-Memory Column Store (IMCS). Oracle Database 12cR2 dramatically expands the capabilities of DBIM, making it even simpler to implement, monitor, and manage while extending its reach to more complex execution plans, expanding its utility to Active Data Guard (ADG) instances, and enabling capture of frequently-evaluated expressions in the Expression Statistics Store (ESS).

Session Outline:

Through presentations and examples using Swingbench’s latest TPC-DS query generation features, this session will illustrate how Oracle 12.2 Database In-Memory:

- Dramatically speeds execution of analytic queries through In-Memory Column Store (IMCS)

- improves the management and monitoring of the IMCS

- Improves complex query execution through improvements like Expressions Statistics Store, In-Memory Filtering, and Parallel Execution



  1. Database In-Memory: A Quick Review
  2. Dynamic IMCS Resizing
  3. In-Memory Fast Start
  4. Extending IMCS to Exadata Smart Flash Cache
  5. IMCS, Heat Maps, and Intelligent Evictions
  6. IMCS in Active Data Guard (ADG)
  7. In-Memory Aggregation (IMA) Enhancements
  8. Improved In-Memory Filtering
  9. In-Memory Compression Units (IMCUs) and Parallel Execution
  10. In-Memory Expressions and the Expressions Statistics Store (ESS)
  11. Conclusions

Objective #1:

The attendee will understand how to leverage IMCS’s latest features to dramatically speed the execution of complex analytic queries against millions of rows.

Objective #2:

The attendee will discover how to deploy IMCS against a physical standby database that’s running Active Data Guard (ADG).

Objective #3:

The attendee will learn how to leverage the latest version of SwingBench to generate a representative TPC-DS workload for equitable comparisons of application performance against an Oracle 12cR2 databases.

Session Prerequisites:

To gain the most from this presentation, attendees should be familiar with Oracle Database 12cR1 and the basics of IMCS and columnar projection. Knowledge of Exadata concepts would also be beneficial.

avatar for James Czuprynski

James Czuprynski

Senior Enterprise Data Architect, Viscosity North America
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public... Read More →

Friday December 8, 2017 11:25 - 12:15 IST
Room 1 (Hall 1)