Description
Master Oracle Database 12c Release 2 testing and tuning
Seamlessly transition to Oracle Database 12c Release 2 and succeed in peak performance the use of the step by step instruction and easiest practices contained on this Oracle Press guide. Written by a team of Oracle ACEs, Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability clearly explains methods to identify, investigate, and unravel performance issues. You’re going to discover methods to use troubleshooting tools and test rigs, optimize code and queries, evaluate database performance, perform realistic application testing, capture and replay actual production workloads, and employ Oracle Database In-Memory.
•Establish benchmarks and evaluate application workload performance
•Configure and deploy SQL Tuning Advisor and SQL Get entry to Advisor
•Maximize efficiency the use of Oracle Database In-Memory and In-Memory Advisor
•Identify and repair poorly running code with SQL Monitor
•Uncover database problems the use of Real-Time ADDM and Emergency Monitoring
•Work with database workload capture and replay
•Analyze third-party code with Workload Intelligence
•Identify database objects so they can benefit most from In-Memory Column Store (IMCS)
•Monitor and manage IMCS objects with In-Memory Central