UTOUG Training Days 2018

Oracle Database 12.2.0.1 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries. This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and nonresident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.