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

by Joyjeet Banerjee

Overview

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

Product Details

ISBN-13:	9781259586170
Publisher:	McGraw Hill LLC
Publication date:	02/22/2017
Sold by:	Barnes & Noble
Format:	eBook
Pages:	288
File size:	19 MB
Note:	This product may take a few minutes to download.

About the Author

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.

Table of Contents

Chapter 1: Database Architecture
Chapter 2: In-Memory Architecture
Chapter 3: Implementing In-Memory
Chapter 4: Implementing In-Memory with Real Application Clusters (RAC) and Multi-Tenant
Chapter 5: Database In-Memory Advisor
Chapter 6: Optimizing Database In-Memory Queries
Chapter 7: In Memory and Engineering Systems
Chapter 8: In-Memory in Action Hands-On Lab
Appendix A: Installing Oracle Database and Enabling In-Memory