Sangam17

Session Abstract:

Originally introduced in Release 12.1.0.2, 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

Agenda:

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.