Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability
Published on 27. October 2017
Book
Paperback/Softback
432 pages
978-1-260-02596-5 (ISBN)
Description
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Master Oracle Database 12c Release 2 testing and tuning
Seamlessly transition to Oracle Database 12c Release 2 and achieve peak performance using the step-by-step instruction and best practices contained in 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 how to identify, investigate, and resolve performance issues. You will discover how 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 Access Advisor
*Maximize efficiency using Oracle Database In-Memory and In-Memory Advisor
*Identify and repair poorly running code with SQL Monitor
*Uncover database problems using Real-Time ADDM and Emergency Monitoring
*Work with database workload capture and replay
*Analyze third-party code with Workload Intelligence
*Identify database objects that will benefit most from In-Memory Column Store (IMCS)
*Monitor and manage IMCS objects with In-Memory Central
Master Oracle Database 12c Release 2 testing and tuning
Seamlessly transition to Oracle Database 12c Release 2 and achieve peak performance using the step-by-step instruction and best practices contained in 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 how to identify, investigate, and resolve performance issues. You will discover how 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 Access Advisor
*Maximize efficiency using Oracle Database In-Memory and In-Memory Advisor
*Identify and repair poorly running code with SQL Monitor
*Uncover database problems using Real-Time ADDM and Emergency Monitoring
*Work with database workload capture and replay
*Analyze third-party code with Workload Intelligence
*Identify database objects that will benefit most from In-Memory Column Store (IMCS)
*Monitor and manage IMCS objects with In-Memory Central
More details
Language
English
Place of publication
OH
United States
Illustrations
140 Illustrations
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 23 mm
Weight
805 gr
ISBN-13
978-1-260-02596-5 (9781260025965)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Jim Czuprynski is an Oracle ACE Director and Certified Master with over 35 years of experience in information technology. He is currently an Oracle database consultant.
Deiby Gomez is an Oracle ACE Director with certifications like Oracle Certified Master 11g and Oracle Certified Master 12c. He is a frequent speaker in important events of Oracle around the world.
Bert Scalzo is an Oracle ACE, speaker, consultant, and senior product manager for database tools at Idera. He spent 15 years architecting DBA features for the popular Toad product line.
Content
Part I: Tools and Test Rigs
Chapter 1: Presenting Tools for Tuning
Chapter 2: Testing Methodology
Part II: Digging Deeper: SQL Performance Management Tools
Chapter 3: SQL Tuning Advisor
Chapter 4: SQL Access Advisor
Chapter 5: SQL Plan Management
Part III: It's Running Slow: Database Performance Evaluation
Chapter 6: SQL Monitor
Chapter 7: Real-Time Operations Monitoring
Chapter 8: Real-Time ADDM & Emergency Monitoring
Chapter 9: ASH Analytics
Part IV: Testing to Destruction: Real Application Testing
Chapter 10: SQL Performance Analyzer
Chapter 11: Database Capture and Replay
Chapter 12: Database Workload Replay
Part V: A Brave New World: Database In-Memory
Chapter 13: Database In Memory Advisor
Chapter 14: In-Memory Central
Part VI: Conclusions and Best Practices
Appendix A: Other Performance Tuning and Testing Tools
Appendix B: Code Examples and Listings
Appendix C: References
Chapter 1: Presenting Tools for Tuning
Chapter 2: Testing Methodology
Part II: Digging Deeper: SQL Performance Management Tools
Chapter 3: SQL Tuning Advisor
Chapter 4: SQL Access Advisor
Chapter 5: SQL Plan Management
Part III: It's Running Slow: Database Performance Evaluation
Chapter 6: SQL Monitor
Chapter 7: Real-Time Operations Monitoring
Chapter 8: Real-Time ADDM & Emergency Monitoring
Chapter 9: ASH Analytics
Part IV: Testing to Destruction: Real Application Testing
Chapter 10: SQL Performance Analyzer
Chapter 11: Database Capture and Replay
Chapter 12: Database Workload Replay
Part V: A Brave New World: Database In-Memory
Chapter 13: Database In Memory Advisor
Chapter 14: In-Memory Central
Part VI: Conclusions and Best Practices
Appendix A: Other Performance Tuning and Testing Tools
Appendix B: Code Examples and Listings
Appendix C: References