Publication Cover

Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance, 1


Published: February 2017
ISBN: 1259586162
e-ISBN: 1259586170

Book description:

Master Oracle Database 12c Release 2's powerful In-Memory option

This Oracle Press guide shows, step-by-step, how to optimize database performance and cut transaction processing time using Oracle Database 12c Release 2 In-Memory. Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance features hands-on instructions, best practices, and expert tips from an Oracle enterprise architect. You will learn how to deploy the software, use In-Memory Advisor, build queries, and interoperate with Oracle RAC and Multitenant. A complete chapter of case studies illustrates real-world applications.

• Configure Oracle Database 12c and construct In-Memory enabled databases • Edit and control In-Memory options from the graphical interface • Implement In-Memory with Oracle Real Application Clusters • Use the In-Memory Advisor to determine what objects to keep In-Memory • Optimize In-Memory queries using groups, expressions, and aggregations • Maximize performance using Oracle Exadata Database Machine and In-Memory option • Use Swingbench to create data and simulate real-life system workloads

Joyjeet Banerjee (Fremont, CA) works as an enterprise architect with Oracle’s Engineered System team. He helps Oracle customers migrate from legacy systems to engineered systems. Joyjeet is a regular speaker at OAUG, Oracle Collaborate, and Oracle OpenWorld.