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