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

ISBN-13: 9781259586163 / Angielski / Miękka / 2017 / 288 str.

Joyjeet Banerjee

Opis

Master Oracle Database 12c Release 2's powerful In-Memory optionThis 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